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 10...
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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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