Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Communauty,
I have an issue of syntax in formula (expression) COUNT if two conditions.
Is this : =Count({$<[Payment Month]= {"$(=Month(Date(Today() -1)))"}>} {$<POT={'Paid on Time'}>}POT)
Condition 1 is Current Month (minus 1 day)
Condition 2 is POT = "Paid on Time"
But is doesnt run (Error). I want to Know where I mistake in the Syntax ?
Help, Please
IT should be as below.
Count({$<[Payment Month]= {"$(=Month(Date(Today() -1)))"},POT={'Paid on Time'}>}POT)
Thank you very much !
Perfectly !
If you got the answer, please mark the post as correct and like relevant post.