Jump to content

Total based on conditional format


This topic is 956 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

 

Link to comment
Share on other sites

1 hour ago, JMart said:

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

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.

2 hours ago, JMart said:

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

Do you really need two calculation fields for this?

 

Link to comment
Share on other sites

This topic is 956 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.