Error in expression : if takes 2-3 parameters

[krithikarees]

I am trying to create a variable  if Clearing date is null or greater than calendar date (which is the selected date)  to put it in a aging bucket  --- if it falls in a criteria else needs to be $0 if it has a clearing date.

the aging bucket expression I already have in place is :: (Which works great!)

=sum(if($(vCalendarDate)- num([Net due date]) > 60 and $(vCalendarDate) - num([Net due date]) <= 90, [Debit/Credit Amount],0))

this is the variable expression I need help with :

IF ( isnull  ( num  (  [Clearing Date] ) )  or IF  (  num  (  [Clearing Date] > Calendar_Day  ) ))

Can anyone help me with this?

[sunny_talwar]

May be like this

If(IsNull([Clearing Date]) or [Clearing Date] > Calendar_Day, .....

[krithikarees]

That did not work. I am not sure why It gives me that error

[JustinDallas]

What are you trying to say with this?

 num  (  [Clearing Date] > Calendar_Day  )

[jerifortune]

Try passing the date field through GetFieldSelections() since you want the calendar date based on user selection.

[sasiparupudi1]

If(IsNull([Clearing Date]) or [Clearing Date] > Calendar_Day,'Age bucket',0)

[krithikarees]

Clearing date is the closing date of invoice and Calendar date is the date based on selection.