Conditional table formatting using dynamic value

Question & Answer
,
1

Is there a way I can define conditional formatting based on a dynamic value stored in a variable or parameter? Currently it’s fixed value as shown in the example below:

Instead of hardcoding 4.57, I want to keep it dynamic so that I can define different threshold values for different products.

image
image526×854 42.6 KB

2

Hi Kumar - You can write a calculated field that makes the comparison:
ifelse(avg(answer_score)> ${parameter}, 1, 0)

And then set your conditional formatting rule off of that field ( =1 for true)