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

    Numbers doesnt work for both parameters


      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.



      Case [Currency Local/USD]

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

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


      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