Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe...
LEFT JOIN(OriginalTable)
LOAD
Type,
LEAamt/sum(TOTAL LEAamt) as Calc
RESIDENT OriginalTable;