2 Replies Latest reply on Jan 2, 2014 7:30 AM by john.finn

    Creating a calculated field (% Difference) based on two other calculated fields




      I have created two calculated fields to show sales (and qty sold) based on a selected date range and selected date range minus 1 year.

      I am now trying to create a % difference for both periods (current as a % of previous years sales). I am using a calculated field as follows:

      Sales Diff=>   [Curr Sales] / [Sales -1 Year]


      However this giving me NULL data. I have tried using SUM() but this causes the workbook to be unresponsive (presume it doesn't like this)...


      Can anyone point me in the right direction please?


      I have attached current test workbook.