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.
It's really not clear what you're trying to ask or do because you haven't provided enough context.
Start with a packaged workbook - Packaged workbooks: when, why, how and provide some further information on your sample data and your expected result.