4 Replies Latest reply on May 15, 2014 1:54 PM by john ripper

    Using Calculated Fields

    Aman Lamba
      DateSalesPurchases
      Jan 1 20121030
      Jan 1 20126020
      Jan 1 20122040
      Jan 2 20123550
      Jan 2 20124050
      Jan 3 20125050

       

      With this data I want to calculate a field say; X = Sales / Purchases for each date. I've used a calculated field for it. But, this calculated field doesn't return apt value. For Example, for January 1 2012 I should get,

       

      DateSum of SalesSum of PurchasesX
      Jan 1 201290901

       

      Instead it gives the value of X as 3.83 instead of 1. Please advise!!

       

      Thanks,

      Aman