Total based on conditional format

[JMart]

Night all,

 

Is there a way to get a count\s based on a conditional format. I have two a calculation field to determine time between to entries, then i have a conditional

format for the calculation field if < 0 = color is "red", if > 900 = Color " pink. Is there a way to know how many are red and how many are pink.

 

Thanks

 

[comment]

  On 8/16/2021 at 5:34 AM, JMart said:

Is there a way to know how many are red and how many are pink.

Expand  

No, but there is a way to know how many are less than zero and how many are over 900. The best way to implement this depends on what exactly you want: your title says "total" - which is very different from "how many".  If this is for a report, you could add a calculation field along the lines of:

( Result ≥ 0 ) + ( Result > 900 )

Then sort your records by this field and use a summary field in a sub-summary part to count the records in each group. And to avoid repeated evaluation of the same thing, change your conditional formatting to use this calculation field too. 

P.S.

  On 8/16/2021 at 5:34 AM, JMart said:

I have two a calculation field to determine time between to entries

Expand  

Do you really need two calculation fields for this?