Skip to Content
0
Former Member
Sep 17, 2007 at 08:01 AM

Calculated KF using IF Else statement

28 Views

Hi All,

I want use in my Calculated KF IF ELSE statement , this is my requirement like

If payment date exists, then PNA = Payment Date - Invoice Due Date. Else, PNA = today's date - Invoice Due date (same value as Days in Arrears).

Payment and invoice due date as a keyfigures , please let me know the formula ....

Thanks

kk