Need Expression?

[khadeer]

Hi Everyone,

I have Closing Balance for every year i.e for suppose for march 2011(financial year)

Let it be 5000

And every month we have value, Suppose

Apr= 500

May= 100

June= -200

when i am calculating result my formula is Closing balance of that year or opening balance of present year( 5000) + Month Value(Respective Months)

then for Apr Mnth my closing is 5000+500 = 5500

                                     May     5500+100= 5600

                                       June   5600+(-200)=5400

This value i am getting, but if iselcted Apr+ May .... My result should be Apr Opening(5000)+May Closing(5600)= 10600

Like this if i selected May n June 5500+5400= 10900

How i can do this in dynamically. Help me regarding this.

[#2]

hi

try this

=openingbalence + sum({<month = { "> = $(=only(month)"}>}amount)

hope this helps you

[khadeer]

Hi Vishwarajan,

Its not working.

[er_mohit]

hi see the attached file

[khadeer]

Hi iamqvsap

for 3 months, suppose if i selected Apr, May, June

5000+5400= 9400

if selected May June July then(let June= 300)

5600+5700= 11300

[#6]

If i understood your post ,it seems like we should take maxumum and second maximum month for the calculation (if 3 months are selected).

= sum({$<MonthId=  {$(=max(MonthId,2))} >}OpeningBalance)

+

sum({$<MonthId=  {$(=max(MonthId))} >}ClosingBalance)

[khadeer]

Its not working

[khadeer]

Hi iamqvsap,

we r near to that, but i need first selected month means if user selects Apr, May Jun... it dynamically take first one means Apr instead 2 in that expression.

= sum({$<MonthId=  {$(=max(MonthId,2))} >}OpeningBalance)

[khadeer]

Anyone is there to solve this issue.

[#10]

If you want first month of the selected period, then you go here

sum({$<MonthId=  {$(=min(MonthId))} >}OpeningBalance)

  +

  sum({$<MonthId=  {$(=max(MonthId))} >}ClosingBalance)