Calculate "BudgetTarget" Column in table.

[infosense_devel]

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.

[sunny_talwar · Accepted solution]

Try this:

Sum(TOTAL {<PATH_SELECT =, [Common_Day (#)]=, REC_TYPE = {'BudgetRec'}>} DAILY_BUDGET * XRATE_CONST * RATE)

[infosense_devel]

Thanks a lot.. it is working exactly what i needed ..