Hello: This is my first post on a FM Forum.

I have buttons that run reports (Scripts) based on two fields. 1) Status 2) Quote Principal. There are 44 buttons total that run specific reports for my business. I would like to look at each button and see a number displayed that tells me how many records currently exist that match the criteria of that button. I have an example of a calculation field that counts records that I have been trying to modify, but, I can't seem to make it count the number of records matching the two values. Currently I have made a new calculation field for one partular button called label 3d ip. This is my calculation so far which is bringing up a displayed number, but since I can't seem to figure out the rest of the calculation, it brings up the wrong number...(but, it doees display a number, which is a good thing in my world)

"Let(x=Count(Quotes::Quote Principal);

"In Progress" & Case( x > 1; "es") & Case(x >0 ; " (" & x & ")" )&

"¶¶¶InProgress"

)"

My main Question:

1) Can I count and display how many records match in real time from 2 fields with 2 criteria?

Example: Field = Value TRI and Field = Value In Progress

Any thoughts or help? Yes, I am a little over my head on this one. Thank you in advance.

Hi and Welcome :

Example: Field = Value TRI and Field = Value In Progress

To be honest I'm not 100% sure what you're on about here, could you post a sample, or a screenshot of what your after?