Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a situation where I have date field "Movement date" in the date format "19/09/2023". i need to calculate count of claims.
I wrote this expression :
" count({$<[Movement Date]={"= $(Date(max([Movement Date])-1),'DD/MM/YYYY')"}>}[Claim Number]) " .
I also tried this expression : "count({$<[Movement Date]={"= $(=max([Movement Date]))"}>}[Claim Number])"
The expression shows ok, but the result is 0, or it doesn't show any result. The count must show as 2258.
Any help is appreciated.
Thanks in advance,
Niranjana
Hi, try this:
=count({$<[Movement Date]={"$(=(Date(max([Movement Date])-1,'DD/MM/YYYY')))"}>}[Claim Number])
I changed 2 parts, bracket place and this '{"= $(' part to '{"$(=(, but I don't know which change corrected the formula. I'll probably never learn to write set analysis correctly, so I always have a few examples saved to check syntax which works 🙂
Hi, try this:
=count({$<[Movement Date]={"$(=(Date(max([Movement Date])-1,'DD/MM/YYYY')))"}>}[Claim Number])
HI , Thanks a lot!! It worked..is it because of bracket?
I changed 2 parts, bracket place and this '{"= $(' part to '{"$(=(, but I don't know which change corrected the formula. I'll probably never learn to write set analysis correctly, so I always have a few examples saved to check syntax which works 🙂
Thanks a lot! same issue is there...that of brackets.....ur explanation and having syntaxes is bang on!