Skip to Content
0

Analysis for Office 2.4 Excel function for dimensions

Mar 21, 2017 at 03:22 PM

143

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Matthew Guthrie Jun 16, 2017 at 02:09 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Johnny H. Jan 29 at 10:59 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded