Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
i have scenario in which i have to show "Date", "Budget MTD" and "Target Budget" (final accumulated number of Budget MTD).
Please take a look at below image.
Formula for for "MTD Budget" :-
=Rangesum(above(total sum({<PATH_SELECT =,[Common_Day (#)]=,
REC_TYPE = {'BudgetRec'}>}DAILY_BUDGET*XRATE_CONST*RATE)
,0,rowno(total))
)
Thanks in advance.
Try this:
Sum(TOTAL {<PATH_SELECT =, [Common_Day (#)]=, REC_TYPE = {'BudgetRec'}>} DAILY_BUDGET * XRATE_CONST * RATE)
Try this:
Sum(TOTAL {<PATH_SELECT =, [Common_Day (#)]=, REC_TYPE = {'BudgetRec'}>} DAILY_BUDGET * XRATE_CONST * RATE)
Thanks a lot.. it is working exactly what i needed ..