Table conditional format with parameter


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! :slight_smile:

1 Like