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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by MSlearner

  1. MSlearner

    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...
  2. MSlearner

    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...
See more

Part and Inventory Search

Back
Top