4 Replies Latest reply on Dec 7, 2016 6:09 AM by Walt Reed

    Table Calculation

    Pragati G

      I have a data set like below .I want to get a calculated field for New Amount. For a particular category ,divide the amount with the highest index value for all the clients to arrive at New Amount. Any help would be highly appreciated

      CategoryClientTotal AmountIndexNew Amount
      1A1001=100/2
      B1002=100/2
      2C2001=200/3
      D2002=200/3
      E2003

      =200/3