Fetching Balance Information From 2 or More Payroll Periods
We have a requirement to fetch the balance of an element's input value for 2 or more payroll periods in a fast formula. For instance, element A has an input Amount as 10 in May, 20 in June and 30 in July. When we run the formula in Aug, we'd like the balance to return 50 (July + June) in the output.
I believe there is no direct dimension that can be used for this purpose.
Any alternatives or thoughts on achieving this requirement (apart from value sets) would be useful. If its possible to using the any alternate dimension, change the context, and somehow achieve this, that would help.