Calculate Metric Based on Prompt result.

[banda27]

I have a Prompt with two options '0' or '1'. I have a metric with a formula. This formula needs to be changed according to the result of the Prompt. I mean change of formula means calculating the metrics with different facts. Can someone suggest me a solution.

Thanks for your help.

 

[JRO061601]

I don't know if you are over-simplifying your problem, but why not just build two separate metrics create a prompt that allows the user to choose which metrics get put on the report (object prompt), rather than make them choose a '0' or '1', and have that determine the formula used?

If your problem is more complex, maybe you can play with case statements to get something working. For example:

CASE WHEN PROMPT=0 THEN FORMULA1 ELSE FORMULA2 END