Dividing (not formating) all the results by 1000

ValB

Hello,

Is there a quick way, in Anaplan XL to divide all the results by 1000 without creating a measure for every row or every column?

ElizabethS

You can create custom calculations that can be applied to a specific member, and that would apply across all rows, for example. For example, I applied the custom calculation to my line item Revenue (drag and drop that member into the expression and then just add "/ 1000.

You will then need to add this custom calculation to your grid.

This is the final result (showing Revenue in thousands) - note you can drag the custom calculation to be directly under Revenue and format it like any other member - I just chose to put it at the bottom of the grid.

However, I am curious why you would not want to use Excel's native functionality to display values in thousands? If you added custom formatting, you could apply it to all members at once (for example, all line items).

Apply the custom format (#,##0,) - the comma at the end converts the number to thousands.

If you only want this to apply to a specific grid you can name your grid in the Grid Properties and then apply that in the formatting tab as seen here. OR if you don't apply a specific grid name it will apply to all grids in the workbook by default (other than those that have the apply formatting unchecked in the properties).

The Excel Approach is more scalable and sustainable since you don't have to update the calculations when new members are added - but the drawback is that it is a bit of a blunt instrument and would apply to all line items equally throughout the workbook unless managed in the formatting tab.