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

    john.finn

      Hi,

       

      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.