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
