SAC Story - Is a parameter (or variable) possible at the Formula Bar?

[honza111]

Hello all,

Is it possible to use some parameter/variable e.g. 'Control Input' from the story instead of the constant 1000?

We would like need to be able to change the constant 1000 in View mode.

Thank you.

[N1kh1l · Accepted solution]

honza11

I do not think you can use it directly. But you can try this workaround

• Create a calculated measure using the input control

Use this measure from the table in your formula. Format the measure with white color so that it gets invisible. Unfortunately you cannot hide the row/column

Hope this helps !!

Nikhil

[honza111]

Great trick, it works perfectly!

Thank you very much Nikhil.

[N1kh1l]

honza11

Glad it helped you. Could you accept the answer and close the thread

Regards

Nikhil