2 Replies Latest reply on Jun 7, 2018 10:06 AM by Doris Liu

    Calculated Field for Time Series Data

    Doris Liu

      Hey guys,

       

      I'm working with a dataset that contains transaction data including amounts, fee, refunds and settlements. They have been filtered by month and all the sums have been correctly calculated by month. But when I tried to add a calculated field that calculates [Amount]-[Fee]-[Refund]-[Settlements] for each month, it returns 0 for every month when it's not supposed to.

       

      Screen Shot 2018-06-06 at 11.25.27 PM.png

       

      Should I clean the data at data source or there is a way to simply apply the logic "[Amount]-[Fee]-[Refund]-[Settlements]" to sums of each month respectively?