budget amount problem

[arulsettu]

Hi i am calculating actual and budget amount.

my budget table contain amount filed like bd_jan, bd_feb, bd_mar.....bd_dec .

so as per Jagan suggestion i did like this

Temp:

CrossTable(Month, Bud_amount,6)

LOAD

     COMP_CODE & '-' &LOB_CODE as %key,

     LOB_CODE,

     BD_YEAR,

     BD_TYPE,

     BD_CR_DT,

     BD_CR_UID,

     BD_JAN,

     BD_FEB,

     BD_MAR,

     BD_APR,

     BD_MAY,

     BD_JUN,

     BD_JUL,

     BD_AUG,

     BD_SEP,

     BD_OCT,

     BD_NOV,

     BD_DEC

FROM

(qvd);

//to make common month for trans detail and budget

Concatenate(Trans_detail)

LOAD

*,

month(bud_date) as Bd_monthname; 

LOAD*,

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

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

Resident Temp;

DROP TABLE Temp;

to create common calendar by concatenating budget and actual table i am able to get correct result for both actual and budget.

now my problem is i can able to get budget amount for budget_type=general expenses.

sum({<BD_TYPE={'GEN_ADMIN_EXP'}>}Bud_amount).

for budget_type=gross_premium it showing only zero.

sum({<BD_TYPE={'Gross_Premium'}>}Bud_amount)

can any one suggest me why?

thanks

[jonathandienst]

Without being able to see your source data an complete load script, the cause is anyone's guess...

[arulsettu]

Hi Jonathan,

                    please check this app !

[arulsettu]

is this app enough please let me know

[arulsettu]

plz someone suggest

thanks

[arulsettu]

if i select LOB_CODE from budget table i can able to get the budget amount alone. not actual vale.

and if i select the ACNT_FLEX_06 i can get actual value alone not budget value.

these two fields having same values

account and budget table are linked

can anyone suggest whats wrong here

thanks

[arulsettu]

any ideas plz its emergency....

[arulsettu]

any help guys