What-If Analysis

[#1]

Hi all,

While doing what if analysis, how to take two fields into consideration. For example see below image. I need to take Energy loss in my expression . At present calculated energy loss is 18.4% that means my pointer should be nearer to 20, when what if Energy sales is 10111155 . can any one help.

My exp :  Sum  ( distinct TOTAL_ENERGY_SALES )*(1-vEnergyLoss/100)  

[Anonymous]

Janaki

can you explain what exactly you want . Your problem is not clear .

If possible attache sample data and sample QVW and expected result .

[#3]

Hi Chandel,

Nice to see you again, Take that image as ref ,in that image What if Energy Sales field should reflect with Energy Loss .At the moment it is not happening.The exp I used for what if Energy sales is .

Sum  ( distinct TOTAL_ENERGY_SALES )*(1-vEnergyLoss/100)  

[#4]

Hi Chendel , Sorry for the late reply, PFA

My requirement is to show energy loss changes by what if analysis. can you help me on this @chendel