Hi!
I want to use the great new calculation editor.
My short question is:
I want to count a Number of Talks with my clients
but only if a certain condition is mit (they were
there vs. they cancelled the appointment).
I know how the COUNT Function works – but how
do i join that with an IF Function. Is there
a Function like “Count only If” ?
Appreciate your help very much, thank so much!
Manuel
Hi Manuel,
You could accomplish this by using the IF statement (or IFEMPTY) and have it return the value 0 or 1 if the condition is met.
Then you could total up that field to display the result by using the Calculation Summary function to display the result at the bottom of the records list view or you could use the TOTAL:: function when selecting a field from a related form’s fields to total the value of that Calculation field in the child form. I’m not sure how you have your form setup, so those are the two options.
Does that make sense?
.
