calculate amount

[arulsettu]

hi

     i am calculating budget amount. i am having budget amount month wise like this

BD_JAN,

     BD_FEB,

     BD_MAR,

     BD_APR,

     BD_MAY,

     BD_JUN,

     BD_JUL,

     BD_AUG,

     BD_SEP,

     BD_OCT,

     BD_NOV,

     BD_DEC

so i calculated like this

sum({<BD_TYPE={'GEN_ADMIN_EXP'}>}BD_JAN+BD_FEB+BD_MAR+BD_APR+BD_MAY+BD_JUN+BD_JUL+BD_AUG+BD_SEP+BD_OCT+BD_NOV+BD_DEC)

the issue is i tried to show this by month wise but the amount values are incorrect.

anyone suggest me how to calculate this amount fields together.

thanks

[#2]

hi,

you can use like this.

LOAD

BD_JAN,

   1  as Month,

year  //coming from table

Resident Table;

concatenate

LOAD

BD_FEB,

   2  as Month,

year  //coming from table

Resident Table;

concatenate

LOAD

BD_MAR,

   3  as Month,

year  //coming from table

Resident Table;

concatenate

LOAD

BD_APR,

   4  as Month,

year  //coming from table

Resident Table;

concatenate

---

--

concatenate

LOAD

BD_DEC,

   12  as Month,

year  //coming from table

Resident Table;

by this you will get month and year comming from your table.

then you put formula in expression.

Regards

Vimlesh

[arulsettu]

hi

     this BD_JAN,BD_FEB are not month fields. budget amount contains in the field.

ex: BD_JAN having jan month budget amount.

thanks

[arulsettu]

any ideas?

[ziadm]

Use a Calender Table having Month Field in the Calendar and linking your budget table to your calender

to sum the budget for all months use set analysis

sum( {$<Month= >} Budget)

[ziadm]

Creating A Master Calendar

[arulsettu]

Hi

     Month coming from another table called trail_balance. i made link between two tables.

even no luck

thanks

[arulsettu]

please suggest some adivce

[jagan]

Hi,

Try using CrossTable() and extract month name from the field name.  If possible attach some sample data.

Regards,

Jagan.

[#10]

hi,

ya i know that so i have told you that creat a common amount with Month,

LOAD

BD_JAN as Amount,

   1  as Month,

year  //coming from table

Resident Table;

concatenate

LOAD

BD_FEB as Amount,

   2  as Month,

year  //coming from table

Resident Table;

concatenate

By this you will get month in a common field and when you will select month this will give you result according month. or if you will select year then it will give you a result in year.

Regards

Vimlesh