7 Replies Latest reply on Nov 17, 2016 7:13 AM by Eleonor Hellblom

    Using an calculated field in YTD calculations

    Eleonor Hellblom

      Hi,

       

      I want to calculate something by YTD and also be able to compare it to last years YTD.

      To do this I am using this function:

      Calculation Issue.png

      But as you can see I get an error. If I replace 'Fixed Calculation' to 'Sales' (in Superstore) it works. How can I do this with a calculated field?

      It doesn't have to be this YTD calculation, so please if you have another way to calculate YTD then let me know!

       

      This is the 'Fixed Calculation':

      Fixed Cal.PNG

       

      See attached workbook as well

       

      Thank you in advance!