If condition issue

[nareshthavidishetty]

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..

[ValeriyaBartosh]

hello, could you please add qvw?

[Anil_Babu_Samineni · Accepted solution]

Remove NOT APPLICABLE and Test?

[sangeess21]

Try removing ,'NOT APPLICABLE'

[ValeriyaBartosh]

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