1 Reply Latest reply on Jul 19, 2016 8:37 AM by amulya.sharma

    Return Division corresponding to row month

    amulya.sharma

      Hi,

       

      For a table:

       

      MonthSourceNumDenom
      May-201612830
      May-201621015
      June-201614042
      June-201621523

       

      I wanted to please know how to create a calculated field in two ways:

      1) Return a Field=Num/Denom for Source 1 and 2 for only June-2016 explicitly (or any corresponding row month)

       

      2) Return a Field=Num/Denom for the previous month in the Month column from the current month in time (Current month is July. So I want the division to be for fields corresponding to June 2016)

       

      Thanks.