1 Reply Latest reply on Sep 14, 2016 9:48 PM by Kathryn Bridges

# Parameter based on a calculated field

Hello,

I am having a requirement where I need to create a parameter that can alter the value of a calculated field. However, the values that the parameter can take is also dependent on another calculated field. Here is the scenario that I am trying to achieve.

Calculated field A is derived by an expression involving many calculated fields. For example: A= ((B+ C)/D) * E

Also, Calculated field B is itself dependent on some fields. For example B = Sales*Discount. Let us assume some of resulting values of this calculated field are 1000, 2000, 3000, 4000, 5000

Now I need to create a parameter that allows me to alter the value of Calculated field A based on x% of the values obtained in Calculated field B.

I created two parameters - one that is pulling values form the calculated field B and one that is altering the percentage. Multiplying these two should give the desired results but i will have to show both the parameters to users to adjust. Can this be achieved by using just one parameter?

Any urgent help would be greatly appreciated.

Thanks!

• ###### 1. Re: Parameter based on a calculated field

Hi Shikha,

I'm a little unclear on why you are using a parameter to pull values from the calculated field B. Parameters are not dynamic, so even if the values from B change when filtered, the parameter won't reflect that change.

I'm not completely clear on your data, but it sounds like you can just make an equation for A for those values from B

(i.e. if B>=10 then "Outcome1"

elseif B>30 then "Outcome2"

else C end")

And then only have one parameter changing that percentage.

Otherwise, posting a workbook for us to see what you are talking about specifically would be really helpful.

Thanks.