Skip to Content

Analysis for Office 2.4 Excel function for dimensions

Hi - Is it possible to add a column using AFO and do some logic like the screenshot below? Basically I want column C value, unless C is equal to "Not assigned", then I want D. Logic in first screenshot.

Every time I do...I get Bag for everything, even when Cx is not Bag, except Not assigned, I get a blank. Second screenshot.

Thanks - Kelly

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 16, 2017 at 02:09 PM

    The issue is that AO hard codes the cell reference for this type of formulas even when you drag it.. There isn't a way to do it in the current versions. The best way is to use an excel column not one in the AO table though I'm sure this isn't ideal.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 29 at 10:59 AM

    Hi,

    Could Tammy or another expert confirm if the AO formula functionality doesn’t work for new dimensions (as shown in Kelly’s screenshots) but for new key figures only?

    Johnny

    Add comment
    10|10000 characters needed characters exceeded