Dynamic Conditional Formatting of a Calculated Columns based on a another calculated Column

Question & Answer
, , , ,
1

Hi All, I have created 2 CC fields
Actual Throughput (PC/Hr) = sum({actualthroughput]}/ sum({hours_ran}) ----1
Expected Throughput (PC/Hr) = sum({theoritical_yield}) / sum({hours_ran}) ---- 2

and placed in a table. I want to do a Conditional Formatting for the above 1 CC field based on the below CC field
Legend Throughput =
ifelse( {Expected Throughput (PC/Hr)} < {Actual Throughput (PC/Hr)}, “Green”, “Red”)

Is this possible in QS? Pls help me out or any workaround?

Green – #008000
Red – #FF0000

2

Hi @Venkat.Metadata,
When you’re setting up conditional formatting, you can use a calculated field in the ‘format field based on’ section so if your calculated fields are working correctly and you have those 2 fields added to your table, you should be able to accomplish:

image
image333×270 10.7 KB

Have you tried to setup the formatting for the instance you’ve highlighted above? If so, what was the outcome; did you receive an error of some type?

3

@Hi Brett, I want add conditional formatting on the highlighted Metric

image
image427×153 9.5 KB
—1
based on the below Metric
image

but here the color will be change based on the “Legend Throughput” metric values which i can’t pass in or give manually in 4th & 5th number boxes in the screenshot. ( It will take automatically ).

image
image609×487 21.2 KB

if {Expected Throughput (PC/Hr)} < {Actual Throughput (PC/Hr)} – display Green Color
if {Expected Throughput (PC/Hr)} > {Actual Throughput (PC/Hr)} — display Red Color

It will display background color automatically for the Metric " Actual Throughput (PC/Hr) " in the Table based on above condition

1 Like
4

Hi @Venkat.Metadata,
Apologies for missing your last response. I understand, unfortunately though I believe this is a current limitation within QS. I’ll mark this as a feature request to promote visibility to the support team though!

1 Like
5

Hi @Venkat.Metadata,
While I’ve marked this as a feature request, checking in to see if you had any additional questions?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

6

Hi @Venkat.Metadata,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!