Help

What formula to use

Topic Labels: Formulas
233 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Angelika
4 - Data Explorer
4 - Data Explorer

I need to get the month to date total number of appointments per client, I am still not getting the result that I need I kept getting the total number since they started. Help please

2 Replies 2

Hi,
more details needed, preferably with screenshot of some example - what you get and and what you expect with the current formula text

Does this look right?

Screenshot 2024-11-07 at 9.39.28 AM.png

If so, you can try using a Count field with a conditional like so:

Screenshot 2024-11-07 at 9.39.33 AM.png

Link to base