Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to have the background color for a pivot table that has NULL values in a calculated dimension field
[
if((Sum(SalesAmt)/Sum(Total<[Region],[SalesRepName]>SalesAmt)) > 0, Sum(SalesAmt)/Sum(Total<[Region],[SalesRepName]>SalesAmt), 0)
]
Here is what I was thinking:
Colormix1(if((Sum(SalesAmt)/Sum(Total<[Region],[SalesRepName]>SalesAmt)) = 0,0), red() , white())
I am seeing "-" as opposed to 0, and I think this is causing my colormix function to fail.
In that case may be this:
Colormix1(if(Len(Trim((Sum(SalesAmt)/Sum(Total<[Region],[SalesRepName]>SalesAmt)))) = 0, 0), red() , white())
Hi Sunny,
That did not work
Are there NULL or missing values?
BTW. NULL is not 0 - is a unknown value.
Here is a topic on this
and so far there is not much you can do.
(You can suppress missing value in QV)
Thanks Robert
See my post above..
I just came across the same issue and it can be handled using visual cues background settings rather than in the expression. In my case I defined upper as >=0 (red) and made all other background settings green. Result is that nulls are green.