Hello!
I applied a conditional format to the Table below: if Percentage Variance>10% then, color entire row. Is it possible to have the percentage as a parameter (instead of 10% hard coded)?
Thank you!
1 Like
Hello @celia.borges, you can definitely have this calculation relate to a parameter rather than a hard-coded value. If you set the parameter to default at 0.1 and then provide a way for a user to alter the selection in a control, then you can reference it in an ifelse statement. It would look something like this:
ifelse({Percent Field} > ${PercentParam}, 'Yes', 'No')
Then you can reference this calculated field in your conditional formatting to color the row red when the field is returning ‘Yes’.
I will mark my response as the solution, but please let me know if you have any follow-up questions. Thank you!
1 Like
Thank you! It worked! 
1 Like