1 Reply Latest reply on Feb 15, 2017 4:35 AM by lenaic.ridinger

    How can i % Return Calculation Actual Number not a Sum or Avg number

    Noman Mughal

      Hi All

       

      i have 2 date Value and i need % Return (May 31, 2016 - Value is (45,850) And (June 30, 2016 - Value is 50,735),,,,,,How can i calculate?

       

      1) I want to calculation current date value divided Previous date value -1 (Only Actual Value) not a Avg Value or Sum Value

      AND

       

      2) same Calculation for Current Month last date value divided Previous Month last date value -1 (Only Actual Value) not a Avg Value or Sum Value

       

      3) same Calculation for Current Year last date value divided Previous Year last date value -1 (Only Actual Value) not a Avg Value or Sum Value

       

      4) same Calculation for Quarter 1 to 4 Quarter (Only Actual Value) not a Avg Value or Sum Value

       

      5) same Calculation for Current Week last date value divided Previous Week last date value -1 (Only Actual Value) not a Avg Value or Sum Value

       

      Please Help me out