Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am calculating count of claim number based on category as well difference of date that is like
No Of Unique Claims with status code 'O' and difference between today and received date Greater than 30
No Of Unique Claims with status code 'O' and difference between Edt date and received data Greater than 14
can some one please help me how i implement above date condition in my expression
The interval() is redundant in this expression - this is just a formatting statement so does nothing here:
Count(Distinct If(Today() - [received date],'D') > 30, Claims))
or
Count({<[received date] = {"<=$(=Date(Today() - 30))"}>} Distinct Claims)
Try something like below:
Count(Distinct if(interval(today-received date,'D') > 30,Claims)
The interval() is redundant in this expression - this is just a formatting statement so does nothing here:
Count(Distinct If(Today() - [received date],'D') > 30, Claims))
or
Count({<[received date] = {"<=$(=Date(Today() - 30))"}>} Distinct Claims)
Hi,
You can create flag in your script like-
today()-received date>30, 1,0 as flag
same will be for Edt date -received data > 14 as flag2
and pass this flag in your expression-
Count({<flag={'1'}, status code={'O' }>}Claims)
Thanks,
Neha