Expression help

[danielnevitt]

Hi,

I have the below expression.

(Sum(unpriced_lots)/NetWorkDays(today()+2,final_pricing_dt))*3

I would like to add an IF statement that says IF Diminishing Balance Contract = Y, then

(Sum(unpriced_lots)/NetWorkDays(today()+2,final_pricing_dt))*3 , IF Diminishing Balance Contract = N then Sum(unpriced_lots)

Any help would be appreciated.

Regards,

Daniel

[Anonymous · Accepted solution]

=if([Diminishing Balance]='Y',

     (Sum(unpriced_lots)/NetWorkDays(today()+2,final_pricing_dt))*3,

          Sum(unpriced_lots))

[danielnevitt]

Thanks for your help

[Anonymous]

No problem.  Glad you got what you needed.