Forum Discussion
Calculation Not Working for Calculated Column
Hi Ya'll, I have these 2 formulas: Measure LTIP Shares = ROUNDDOWN(CALCULATE(SUM(LTIP[Amount]))/'Stock Price'[Stock Price Value],0) Sample: 25,000 / 54.78 = 456 shares (the round down el...
Anonymous ,
You can nor measure in a column.
Try a measure like this
PSU =
sumx(Values(LTIP[Management Level]) ,
Switch(
True(),
max(LTIP[Management Level]) IN {"5B","5A","4B","4A","3"},ROUNDDOWN([LTIP Shares]*.25,0),
max(LTIP[Management Level]) IN {"2","1","0"},ROUNDDOWN([LTIP Shares]*.50,0),
Blank()
))
Anonymous ,
You can nor measure in a column.
Try a measure like this
PSU =
sumx(Values(LTIP[Management Level]) ,
Switch(
True(),
max(LTIP[Management Level]) IN {"5B","5A","4B","4A","3"},ROUNDDOWN([LTIP Shares]*.25,0),
max(LTIP[Management Level]) IN {"2","1","0"},ROUNDDOWN([LTIP Shares]*.50,0),
Blank()
))
Doh! You're right!
Thanks so much! I appreciate your help here!