Metric that qualifies on attribute??

[bittmapp]

Can a metric built with a qualification on an attribute. I mean someting like this.


if indicator = Y, then sum(amt) else (sum(amt)*.86)

Thanks in advance.

bitt

 

[iolaper]

You could either use an ApplySimple or use a Threshold.
Thresholds do not require you to come up with any fantastic solutions, but are pretty powerful.
The only catch though is that both your Indicator attribute and your Sum(Amt) metric should be on your grid

 

[mstrdev1]

Look at technical note TN5200-071-0120 on Microstrategy's knowledge base. It has some exmpales on how to use Case fuctions.

 

[FLB]

No need to use applysimple on that one, the case statement and a compound metric will do (the max(flag) metric is just going to need to have the right dimensionality)