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!
-
metric with case function doesn't work as a report filter
Hi, All, I have a metric with a case statement like this: Case((A>0 and B<0),1,0)(A and B both are metrics).This metric works fine individually, but when I put this metric at the report filter or view filter saying 'Metric=1' to get the records that are only satisfied for 'A>0 and B>0', it...- MSlearner
- Thread
- Replies: 0
- Forum: MicroStrategy, Inc. solutions
-
metrics with Case function doesn't sum up
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...- MSlearner
- Thread
- Replies: 0
- Forum: MicroStrategy, Inc. solutions
