Logic Help Required

[abhaysingh]

Hi all,

i have one code lets say LH which contain Sales Value.

and i have targets available against that code but in Bifurcated way like LF-europe(55% of total sales) and LH A++(45% total sales)

how i can map it against singal code LH.

Thanks to all

regards

Abhay

[avinashelite]

as per my understanding,

table1:

LH

1000

table2:

key,Product, %,Actual Amount

1000,A, 56%,10000

1000,B, 44%,10000

your result should be like:

Product, Amount

A,5600

B,4400

if this is what you wanted then, try like below:

Load Key,

Product,

(%*Actual Amount)/100 as new_amount;

this should solve the issue

[abhaysingh]

OK DEAR, i'll try to do and share wid u

[abhaysingh]

hi Avinash,

u r right but i have hundreds of value in a Code Field and LH is one of that for which i have to bifurcate sales value into percentage and for rest it should be 100%.

[abhaysingh]

its done thanks all of you for help...