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 always return no result, even there are records that satisfy this condition. Anyone has any idea or suggestions? thanks a lot in advance
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 always return no result, even there are records that satisfy this condition. Anyone has any idea or suggestions? thanks a lot in advance