Creating a Calculation

[#1]

How do i create a calculation within Analysis. Need a Change % comparing Actual Net Sales Jan YTD 2017 to Jan YTD 2016 and Budget Net Sales Jan YTD 2017 to Jan YTD 2016 shown in the example screen shot.

[TammyPowlas · Accepted solution]

Tina, assuming you are on a later version, you can use Excel formulas for your calculations. Which version are you using?

[former_member751433]

Hi Tammy, i am using version 2.4.0.65048 SAP Business Objects Analysis. thank you for the information.

I see now how this is done now. Insert column preform calculation. Any additional tricks to inserting and saving columns, switching measures and maintaining calc would be appreciated.

Thanks again