data model problem

[arulsettu]

Hi,

I am trying to create a data model to calculate budget amount.

i am having budget table. in that i did

budget:

COMP_CODE & LOB_CODE as %Key

account table:

ACNT_COMP_CODE & ACNT_CODE  as %key

up to this fine. now i need to calculate gross premium for budget.

to create a common calendar i concatenated the budget table to Trans_detail table.

now my budget amount is zero. if i remove concatenation budget is showing but actual amount is zero.

can anyone please tell whats is wrong here. its urgent.....

thanks

[arulsettu]

hi peter please check this

[arulsettu]

Petter the LOB_ACODE and ACNT_FLEX_06 is not getting associated thats the reason i think