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 , 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