1 Reply Latest reply on Nov 2, 2017 11:41 AM by Tom W

    3 months data for a specific field

    Anjal S

      I have a requirement where, I have two fields charges and payments. But in this case my formula is, charges/(payments/30). In this case, I need to get only 3 months of data for payments excluding current month. Is there any possible way we could write a calculative field for this kind of requirement.

       

      I Have data available for more than 12 months. For charges filed we need to get 12 months data but for "Payments" field we need to get only 3 months data. We are using one common Date filter for this whole requirement.

       

      Initially I need to create a filter to get only 3 months of data for payments and then do the above calculation.

       

      Any suggestions would help.

      Thanks !