This content has been marked as final.
Show 4 replies

1. Re: Total Sum calculation based on a dimension
Zhouyi Zhang Aug 22, 2018 5:26 PM (in response to sunny p)
Book1_v10.2.twbx 21.2 KB


2. Re: Total Sum calculation based on a dimension
sunny p Aug 22, 2018 8:13 PM (in response to Zhouyi Zhang)How to avoid Negative values in Misc Time column? I am getting negative values if I add whole data

3. Re: Total Sum calculation based on a dimension
Ankit Bansal Aug 22, 2018 9:01 PM (in response to sunny p)Sunny,
You can use below formula to avoid negative values
if misc time is >0 then misc time else 0 end
use this field to get the total sum.
Hope this helps.
Thanks,
Ankit Bansal

4. Re: Total Sum calculation based on a dimension
Zhouyi Zhang Aug 22, 2018 9:31 PM (in response to sunny p)Hi, Sunny
You can create a calculation for misc time like
Sum(if [Misc time] < 0 then 0 else [<osc time] end)
and replace it in the measures.
ZZ