Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Formatting Calculated Column

Hi Guys,

 

Please refer the below table:

 

I've the two columns in my report i.e Usage and Unit and want the third column which will be Unit(Kwh).

I want the uasge values to get multiplied by 1000 where ever unit is mWh and rest should remain same.

 

I got one part of the expected solution using the below formula but kWh values were missing. Kindly help. me with this.

 

Unit (Kwh) = IF (
VIEW_FORECASTREVENUE[COMMODITY] = "Electric" && [Unit] in{ "mWh" },
ROUND ( VIEW_FORECASTREVENUE[FORECASTEDUSAGE] * 1000.0, 0 )+0)+0

 

Regards,

Himanshu

 

UsageUnitExpected Output Column: Unit(kWh)
43450kWh43450
2430mWh2430000
4500mWh4500000
2365kwh2365
12345mWh12345000
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try like

    Unit (Kwh) = IF (
    VIEW_FORECASTREVENUE[COMMODITY] = "Electric" && [Unit] in{ "mWh" },
    ROUND ( VIEW_FORECASTREVENUE[FORECASTEDUSAGE] * 1000.0, 0 )+0, VIEW_FORECASTREVENUE[FORECASTEDUSAGE])+0

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , Try like

    Unit (Kwh) = IF (
    VIEW_FORECASTREVENUE[COMMODITY] = "Electric" && [Unit] in{ "mWh" },
    ROUND ( VIEW_FORECASTREVENUE[FORECASTEDUSAGE] * 1000.0, 0 )+0, VIEW_FORECASTREVENUE[FORECASTEDUSAGE])+0