I am Unable to Change Format(Incremental RR is in percentage(%) and rest are in numbers($)) When Using Parameters to Swap Fields. I have created one parameter named -Select metric and written calculation as below:

IF [Select Metric]='Avg HH-Balance' then [Average Balance] ELSEIF [Select Metric]='CPI-HH (Checking)' then [CPI-HH (Checking)] ELSEIF [Select Metric]='CPI-A (Any Acct)' then [CPI-A (Any Acct)] ELSEIF [Select Metric]='Incremental RR' then [Incremental Response Rate] else null END

The format it's taking is Automatic but I want the axis to change according to the selection of parameters.Thanks.

1 Answers

1
tagyoureit On Best Solutions

Check out this great answer from Andy Kriebel.