Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to write the expression to get the required results .
My requirement is :-
When I select Fiscal Year =2016 and Fiscal Period =05 .
Then the Detail Table - Anticipated Report must show
The details of Fiscal Year = 2016 and Fiscal Period > 05.
Sample attached.
May be this:
Sum({<fiscal_period = {"$(='>' & Max(fiscal_period))"}>} anticipated_amount)
May be this:
Sum({<fiscal_period = {"$(='>' & Max(fiscal_period))"}>} anticipated_amount)