Forum Discussion

Orlin81's avatar
Orlin81
Copper Contributor
Jul 26, 2020

Price sensitivity Data table not calculating correctly

I am trying to conduct a price sensitivity analysis in excel, however when I input the row and collumn info the only result I get is the linked result I am trying to analyze. For instance if i put in...
BI & Data Analysis
TheAntony's avatar
TheAntony
Iron Contributor
Jul 27, 2020

Orlin81 , it's very hard to visualize your issue. Can you share a sample workbook with confidential information removed?

  • TheAntony's avatar
    TheAntony
    Iron Contributor
    Jul 27, 2020

    Orlin81 , You had 2 issues :

    1. There were no calculations just values in many of the items in the P&L section
    2. The calculations were set to Automatic except for data tables

       

    See attached with both fixed.

Resources