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

[arulsettu]

hi,

    please find the attachment.

thanks

[arulsettu]

Hi Jagan ,

               can you please check the app and tell me how to do it

thanks

[#4]

Hi,

try like this ,may be helpful you.

Regards

Vimlesh

[jagan]

Hi,

Try this script

Temp:

CrossTable(Month, BudgetValue, 5)

LOAD %key, BD_TYPE, COMP_CODE, LOB_CODE, BD_YEAR, BD_APR, BD_AUG, BD_DEC, BD_FEB, BD_JAN, BD_JUL, BD_JUN, BD_MAR, BD_MAY, BD_NOV, BD_OCT, BD_SEP

FROM DataSource;

Budget:

LOAD

*,

Match(Capitalize(Right(Month, 3)), 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec')) AS Month,

MakeDate(BD_YEAR, Match(Capitalize(Right(Month, 3)), 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec')) AS Date

Resident Temp;

DROP TABLE Temp;

Regards,

jagan.

[arulsettu]

hi jagan

          it showing file name must be unique error. and COMP_CODE & LOB_CODE as %key this is for link.

[jagan]

Hi,

Try this script

Temp:

CrossTable(Month, BudgetValue, 3)

LOAD COMP_CODE & LOB_CODE AS %key,

BD_TYPE, BD_YEAR, BD_APR, BD_AUG, BD_DEC, BD_FEB, BD_JAN, BD_JUL, BD_JUN, BD_MAR, BD_MAY, BD_NOV, BD_OCT, BD_SEP

FROM DataSource;

Budget:

LOAD

*,

Match(Capitalize(Right(Month, 3)), 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec')) AS MonthName,

MakeDate(BD_YEAR, Match(Capitalize(Right(Month, 3)), 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec')) AS Date

Resident Temp;

DROP TABLE Temp;