conditional expression

[#1]

hi

i am doing a dashboard to do display statistical data of a budget system.. the months start from Apr to Mar

so as the starting month the cumulative budget (as a example ) should be $100 and for each month $100 should be added so when you come to the Dec month cumulative budget should be $900.

since the present month is Jul the value should be $400.. and if we select Aug the $400 should be displayed without changing to $500 since still we are in the July month..

i am trying to show this in a text box (and $100 is an assumed value there is a variable to define this value call "cum_bud")

i know there should be conditions to check the current month and then to start doing the calculations..

can some one plz help me to create a formula to get the value

will really appreciate the help thank you in advance

[Anonymous · Accepted solution]

Something like this maybe :

= [cum_bud] *

     if ( num(month(today())) > 3 ,

          num(month(today())) -3 ,

          num(month(today())) + 9 )

[#3]

hi bill

if you don't mind me of asking what is 3 and 9 do??

[Anonymous]

To cater for for your year starting at Month 4 and ending Month 3 the following year.