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.

       

      Thanks,

      Prem