4 Replies Latest reply: Feb 27, 2012 11:17 PM by Balaa RSS

    Pivot Table issue


      I have an issue by using function in pivot report.

      I have entered below function in one of the report column - Fact - AR AP Reconcile".AP_INV_PAY_AMT -

      CASE WHEN "Fact - AR AP Reconcile".AP_PAY_AMT != 0 THEN 0 ELSE "Fact - AR AP Reconcile".AP_INV_PAY_AMT END

      When I run this report - I am getting the value in the column even column Fact - AR AP Reconcile".AP_PAY_AMT contain value not equal to zero.

      Pleas let me know if I am doing something wrong.