Budget Input - Direct Selling P&L and GP

[AVHuntley]

Had to modify the row script query by breaking it up into steps.

Was: WITH SET [Step1] AS {{Descendants([GRP99999 - GROSS PROFIT],,leaves) }* Descendants([Clarins Brand],,leaves) * Descendants([Base + Labor],,leaves)} SET [Step2] AS {Descendants([GRP99999 - GROSS PROFIT]) * ([Clarins Brand]) * ([Base + Labor])} SELECT { @cols } ON COLUMNS, NON EMPTY HIERARCHIZE( { NONEMPTY( [Step1], @cols ) + NONEMPTY( [Step2], @cols ) } , POST) ON ROWS FROM [@cube]

Now:

[AVHuntley]

Error on server-build caused by A3 interpreting the value of 0% in the first column of the grid as a row header.

Unexpected error processing DataSet3. Members, tuples or sets must use the same hierarchies in the function.

Note that the apparently empty row on the bottom actually contains white text on white background, so grid does extend down past that.

[AVHuntley]

A3 update address this issue. Seems to build without errors now.

Note to self: double check that all text columns are marked as not subtotaling. (Put "0" in the subtotaling format row in each column with a "1" in the comments format row.)

[caroleszn]

I am getting the below error when running the template

[AVHuntley]

I think this error may have been caused by a bug in the add-in that has now been addressed. Can you try again?

[caroleszn]

Runs without error but same issue as the Ecommerce budget input template for the number formatting of row 41 and 42 of the GP input tab.

[AVHuntley]

I think we've been able to fix this - see explaination in "Budget Input - Ecommerce P&L and GP".

Take a look and let me know. You can also try applying formatting to the grid yourself - it should stick now.