2 Replies Latest reply on Jul 13, 2018 7:58 AM by chandrakanth k

    Parameter control and Calculated field

    chandrakanth k

      Hello All,

       

      I need help with parameter control and calculated field where I need provide total amount based on few logics.

       

      Below are the string values in parameter for which I need to give values.

       

      • Total Overdue
      • Total Payment scheduled to be paid for July (Or
        any given month)
      • Invoices Held due to Vendor Master Issues
      • Invoices held by Sourcing

       

      When "Total Overdue" is selected in parameter then I need to provide total amount (Amountinloccurr2) only for overdue ( Due status)

      When "Total Payment scheduled to be paid for July (Or any given month) "  then Select Month ( payment date) and  provide total amount

      When "Invoices Held due to Vendor Master Issues" Then Select “Vendor held for Banking Verification” & “Vendor on hold for Bank info correction” from V Block And
      select “MDI” from Payment vendor and provide total amount

      When " Invoices held by Sourcing" then Select “STATUS 60 BUYER”  from PBK field and provide total amount.

       

      I used below calculated field but I am unable to split the amount based on the above given logic

       

      CASE [Parameters].[Ask Me]
      when "Total Overdue" then SUM([Amountinloccurr2])
      WHEN "Total Payment scheduled to be paid for a month" THEN SUM([Amountinloccurr2])
      WHEN "Invoices Held due to Vendor Master Issues" then SUM([Amountinloccurr2])
      when "Invoices held by Sourcing" THEN SUM([Amountinloccurr2])
      END

       

      Attached sample workbook.

       

      Regards,

      Chandrakanth.K