Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a scipt where I load all revenue/volumes/categories from our booking systems database. I'm now trying to add an variable price to this and need to do this manually since it does not exist in the booking system. What I want to trigger is when cargo A in harbour X is being transported this triggers an varible cost of Y$.
So my question is how can I add the cost of Y$ to the existing categories I have loaded from the database and create relationship between them, transported cargo A x Y$ = total variable cost for cargo / customer
Many thanks for the help!
Br,
Johan
Hi
Does this calculation need to be done a right data load?
you can use the "Resident" to do an analytical analysis and create a linked backing sheet
Something like
Table_1:
Load
Gate,
Value
From source;
Table_2
Load
Gate,
if(Sum(Value) > 20,2,3) as Cost_Variable
Resident Table_1
Group By Gate;
Hope this helps
regards