Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have used the below if condtion.
if(num([Calendar Date]) - num([Start Date])<=30, '0 TO 30 DAYS',
if(num([Calendar Date]) - num([Start Date])<=60, '31 TO 60 DAYS',
if(num([Calendar Date]) - num([Start Date])<=75, '61 TO 75 DAYS',
if(num([Calendar Date]) - num([Start Date])<=90, '76 TO 90 DAYS',
if(num([Calendar Date]) - num([Start Date])<=180, '91 TO 180 DAYS',
if(num([Calendar Date]) - num([Start Date])<=365, '181 TO 365 DAYS',
if(num([Calendar Date]) - num([Start Date])> 365,'>365 DAYS','UNKNOWN'))))))),'NOT APPLICABLE'
But i'm getting only NOT APPLICABLE.
Please let me know the right one.
Thanks..
Remove NOT APPLICABLE and Test?
hello, could you please add qvw?
Remove NOT APPLICABLE and Test?
Try removing ,'NOT APPLICABLE'
I think , there are some situations when [Calendar Date] or [Start Date] is null, and in this situation if condition gives NOT APPLICABLE like/as ELSE