Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can anyone help me?
I have two graphs. One is a full accumulation (not using the full accumulation check box) with one dimension (time)
The other graph is the same except I have added an additional dimension.
Formula 1: rangesum(above(sum({$<$(EstimateA)>}Cost)/1000,0,100)) -- Correct $31.4M
Dimension: Time
Formula 2: rangesum(above(sum({$<$(EstimateA)>}Cost)/1000,0,100)) -- Not correct $29.6M
Dimension: Category1
This isn't taking into consideration the additional dimension
do you have "Suppress when Value is Null" selected for either dimension in your second chart? otherwise, can you attach a sample qvw?
Yes, looks like there are Cost records that are not associated with any Category1 value.
