script

[Anonymous]

Hello

I have table like this in my datamodel

Month	Type	LEAmt
April	CUSTOM BROKERS	(1,670,858.99)
April	DUTY	(20,790,770.96)
April	FREIGHT INBOUND	(2,243,902.26)
April	FREIGHT OUTBOUND	(23,816,177.97)
April	LOGISTICS OVERHEAD	(1,048.35)
April	WAREHOUSING	(5,730,697.68)
April	TradeUnits	4,051,269.00

i have to create another column in my datamodel it should be like this. please help us in scripting

Month	Type	LEAmt	LEUnitsAmt	calculation example
April	CUSTOM BROKERS	(1,670,858.99)
April	DUTY	(20,790,770.96)
April	FREIGHT INBOUND	(2,243,902.26)
April	FREIGHT OUTBOUND	(23,816,177.97)
April	LOGISTICS OVERHEAD	(1,048.35)
April	WAREHOUSING	(5,730,697.68)
April	TradeUnits	4,051,269.00
April	CUSTOM BROKERS/Units		-0.41	=-1670858.99/4051269
April	DUTY/Units		-5.13	(20,790,770.96)/4051269
April	FREIGHT INBOUND/Units		-0.55	(2,243,902.26)/4,051,269.00
April	FREIGHT OUTBOUND/Units		-5.88
April	LOGISTICS OVERHEAD/Units		0.00
April	WAREHOUSING/Units		-1.41

Please help us in scripting

regards

ramu

[#2]

Maybe...

LEFT JOIN(OriginalTable)

LOAD

Type,

LEAamt/sum(TOTAL LEAamt) as Calc

RESIDENT OriginalTable;