Hi,

I am having problems with validating calculation by Tableau. I tried to trace where the problem is, but I can't figure it out. Can anyone please help me with it. I tried to attach the file, but some member advised that I should hide the info. Hence, if you don't mind, I can send my .twbx file to your email if you need it.

I have attached 2 print screens. One is the summary of my calculation and the other is the bar chart by Org level variance.

My calculation is total allocation - LE used. I have attached the formula below:

SUM([allocation_v3#csv (allocation_v3.csv)].[Total allocated LE])-sum([LE Used])

In the summary, I have 2 problems,

1) at CS other org level, all variance are showing 0 instead of negative number, how can i fix that?

2) if you look at the total variance number by Creative Center group, it is showing -35.7, but i don't know why when i put together in a bar chart, the number change to positive (+71.7). Is there anything wrong? Thanks

Ken

This content has been marked as final.
Show 0 replies