Expand my Community achievements bar.

Conditional Formatting On Reports - Using Integers

Avatar

Level 2

Hello,

So I've been using conditional formatting for a while now, but I've been having a challenge using it with standard integer values, for example to do a greater than, less than, etc.

I think the main thing holding me up is the comparison.operatortype, the existing documentation doesn't have a list of the possible options we can use here and I've not seen any other forum posts about it, so wondering if anyone else has experience with this?
https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/text-mode/use-condition...

Are strings and dates the only options available, or are there more?

For reference, this is the sort of thing I was looking to create:

styledef.case.0.comparison.icon=false
styledef.case.0.comparison.leftmethod=actualLaborCost
styledef.case.0.comparison.lefttext=actualLaborCost
styledef.case.0.comparison.operator=gte
styledef.case.0.comparison.operatortype=int
styledef.case.0.comparison.righttext=plannedLaborCost
styledef.case.0.comparison.trueproperty.1.name=bgcolor
styledef.case.0.comparison.trueproperty.1.value=fa837d
styledef.case.0.comparison.truetext=
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 10

Hi,

 

I do not know, if this will completely solve your issue, but if you will have a look into the API Explorer, you will see, that the fields actualLaborCost and plannedLaborCost do store values as datatype double.

 

So, I would change the corresponding line to

styledef.case.0.comparison.operatortype=double


Regards

Lars