1 Reply Latest reply on Feb 24, 2014 10:30 AM by Tracy Rodgers

    Calculations on the worksheet fields

    Prem Reddy

      Hi All,


      I'm unable to create a calculated fields using the current values on the worksheet. As seen in the workbook there exists two labels "YTD" & "B(W) vs LY", I need to write a formula that divides the values on the worksheet with other value.


      e.g. (Cancellations/Net Retail Flash Sales)*100 that should return 12.5%.


      Similar is the case with all other values i.e. Returns/Net Retail Flash Sales, RTV/Net Retail Flash Sales...


      Attached is the sample workbook.


      Hoping that this could be achieved.