Announcements
cancel
Showing results for
Did you mean:
Master III

## budget amount problem

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)

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)

*,

month(bud_date) as Bd_monthname;

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.

for budget_type=gross_premium it showing only zero.

can any one suggest me why?

thanks

7 Replies
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Master III
Author

Hi Jonathan,

Master III
Author

is this app enough please let me know

Master III
Author

plz someone suggest

thanks

Master III
Author

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

Master III
Author

any ideas plz its emergency....

Master III
Author

any help guys

Community Browser