I have a report with like this, Shipper(Attribute), Amount(Metric).Amount metric defined as "Case(A>0 and B>0),B,0)" (A and B are two seperate metrics), data looks fine after report executed.But, after I click 'Grand total' to get the total of the 'Amount', it gave me '0' as the total even it has data for individual records. I did change the aggregation as 'Sum' and checked 'Allow smart metric' for this metric. I looked at the SQL behind, the case metric is calculated by the Analytical engine, is there anything to do with VLDB settings? Any idea of why this is happening? I will appreciate if anyone could give me some suggestions. thanks advance
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
metrics with Case function doesn't sum up
- Thread starter MSlearner
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question