Conditional Formatting on CrossTab Column with Specific Name

Ignition
1

I have a report with a crosstab table. A sample of the format of the data is as follows:

Stage,ModelNo,Type,Value
1,MX01,Pass,10
1,MX01,Fail,100
1,MX01,Total,110
1,MX01,Yield,0.89
1,MX02,Pass,10
1,MX02,Fail,100
1,MX02,Total,110
1,MX02,Yield,0.10
2,MX01,Pass,10
2,MX01,Fail,100
2,MX01,Total,110
2,MX01,Yield,0.45
2,MX02,Pass,10
2,MX02,Fail,100
2,MX02,Total,110
2,MX02,Yield,0.34

When the Yield column pops up, I want to format as a percentage. Is there a way to do this?

2

I have not ever used the cross tab, so I took some assumptions on your setup. However, when you plug that dataKey in you can do a lot to manipulate the value. Try something like this @dataSet.Value * 100@%.

https://docs.inductiveautomation.com/display/DOC79/Keychain+Expressions

3

Thank you, but that would not work. That would apply that formatting to all of the columns in the crosstab table and I need to apply that formatting to one column in particular.

4

I solved my own problem:

I just converted all of the values to strings, filtered for the yield Type and then apply my formatting.

This is not an elegant solution, but it does work.