4 Replies Latest reply on Sep 16, 2018 11:05 PM by daniel.andell

    Numbers doesnt work for both parameters

    daniel.andell

      I have a parameter for USD or Local currency. It works just fine for the exact same calculation for budget. But when I do it for Quota it doesnt work for USD.

       

      Calculation

      Case [Currency Local/USD]

      when "Local" then [Current_YTD_Sales]-[Quota_Function CY]

      when "USD" then [Current_YTD_Sales_USD]-[Quota_USD CY]
      End

       

      Below is the result in Local currency

       

      Then the result in USD. As you see the diff is equal to the quota and it doesnt take sales-quota.

       

      Hope you can help me understand why the calculation doesnt work for this specific calculation