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.