logic

[capriconuser]

I have this type of data

HEAD                            TYPE                   EXP_TYPE         CODES            

ADS	PN	GE	751-715	10%  to IE
ADS	PN	AE	751-716	10% IE

above tables shows that 10 % goes to IE and other goes to GE 

and in second row 10% go to IE and other 90% go to AE i.e. we must total to 100% not above 100

now here in below that how i distributed % according to above table to make 100% because above table shows that 90% to AE 90% TO GE and 10 % to IE  this because around 190 but i want to make this 100 how i do this or is there any formula we apply to make total 100 %

AND THIS ANOTHER SHEET

head	LE	AE	GE	TE	IE
ADS		90	90		10

[YoussefBelloum]

Hi,

how do you calculate the % ? do you calculate it on the script or on the chart ?

[capriconuser]

% here is given by customer.. and not necessary this is 10% this is may 20% to IE and remaining % to GE