Ratios are not picking correctly with respective product elements in script logic

[BalaValluru]

Hi Experts

I have two sets of data Scope 1 and Scope 2.

In Scope_1- Ratios are saved against 5 Product element wise and All Country wise.

In Scope_2- Having Total Expenses(30000) with some material combinations

Requirement is Scope_2 ( Total Expenses 30000 (fixed) ) * (multiply) Scope_1 (Ratios) with respective product and country = Target results to post at each Product wise /Country level

I have test the logic for two time

1st test only with one product first one Reliance

and second time taking both the products ( Reliance and star health)

For 1st test with first product I have got the correct results ( Reliance picked 30% ratio * 30000=9000)

In second time tested for two product ( Reliance, star health)

Product Reliance wrongly calculating ( 3000*18% = 5400 instead of 30% =9000) and

Product Star Health calculating correctly ( 30000*18%=5400) that means recent ratio is applying to previous products elem ratio and not picking with respective product element/ Ratio's wise.

Appreciate could you please help me to consider the logic with respective ratio multiply with respective 5 product element wise & country level dynamically.

// TOTAL EXPENSES CALLING FROM  SCOPE2


*XDIM_MEMBERSET ACCOUNT = BAS(ALL_ACCOUNTS)													
*XDIM_MEMBERSET COSTCENTER = BAS(ALL_COSTCENTERS)													
*XDIM_MEMBERSET AUDITIDM = BAS(ALL)										`			
*XDIM_MEMBERSET CATEGORY = ACTUAL													
*XDIM_MEMBERSET ENTITY = BAS(1000)													
*XDIM_MEMBERSET COUNTRY = US													
*XDIM_MEMBERSET TIME = 2019.01													
						
													
*WHEN ACCOUNT													
*IS BAS(TOTAL_EXPENSE)													
													
*WHEN MATERIAL													
*IS INHOUSEMAT,EXMAT													


//LOOKUP IS CALLING FROM SAME MODEL TO PICK THE RATIOS FROM SCOPE1
													
*LOOKUP FINANCE													
*DIM RATIO:ACCOUNT = RATIO_R													
*DIM RATIO:COSTCENTER = NO_C													
*DIM RATIO:ENTITY = ENTITY_DUMMY													
*DIM RATIO:RPTCURRENCY = USD													
*DIM RATIO:AUDITIDM = RATIOS													
*DIM RATIO:PRODUCT = RELIANCE
*DIM RATIO:PRODUCT = STARHEALTH													
*DIM RATIO:COUNTRY = IND													
*ENDLOOKUP													
													
													
*REC(EXPRESSION=%VALUE%*LOOKUP(RATIO),PRODUCT =RELIANCE,COUNTRY = IND,CATEGORY = ACTUAL,ENTITY = ENTITY_DUMMY,ACCOUNT = OUTPUTACCT,TIME = 2019.01)													
*REC(EXPRESSION=%VALUE%*LOOKUP(RATIO),PRODUCT =STARHEALTH,COUNTRY = IND,CATEGORY = ACTUAL,ENTITY = ENTITY_DUMMY,ACCOUNT = OUTPUTACCT,TIME = 2019.01)													
													
*ENDWHEN													
*ENDWHEN

Expecting to calculate the logic as below.

Thanks

Kishore V

[former_member186338]

Sorry, but you are starting new question without accepting answer in the previous one (about the same subject)! What is the reason to answer you?

P,S, And the script is incorrect - no reason to use LOOKUP!

[BalaValluru]

Hi vadim.kalinin

Sorry Vadim . Reason for posting in newly again just want to explain the requirement one more time clearly in new thread. not to ignore your answer. I tried as you suggested but Values are not started posting.

Thanks

Kishore V

[former_member186338]

I will not answer here before the previous question will be completed.