Conditional colouring doesn't work for all numbers

[JacobJones]

Hi All,

I'm using this for conditional colouring

networkdays([Date Case Received] , [Date of Appointment]))
> 8 , '#15325a', '#59a14f')

It will work with other numbers, but if it is the number eight, it won't change the color

Any ideas, or this a bug?

Best,

Jacob

[sugathirajkumar]

networkdays([Date Case Received] , [Date of Appointment])) >= 8 , '#15325a', '#59a14f')

please try this

[JacobJones · Accepted solution]

The issue was I wasn't rounding the results, I've included what ended up working:

=IF(ROUND(AVG({< [Date of Appointment] -= {""}, [Date Case Received]={">=$(=ONLY(vArthurStartDate))"}, [Service Name] = {"*CA"}>} networkdays([AxUDV_CaseTriage.Date Case Received] , [Date of Appointment]))) <= 8, '#59a14f','#15325a' )