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
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.