I need to reproduce this type of logic in my script in order to calculate our summarized order margin amount. The below calculations are done on a unit price level. How can I reproduce this logic in my load script. The logic is based on a combination of sales currency and purchase currency. Can someone suggest how to do this?
I'm fairly sure the size is restricted, plus sometimes it simply doesn't work. I'd make the simplest possible sample file using inline data that still demonstrates the problem. If you find you can't make a sample file that demonstrates the problem, then you already have it solved, and just need to figure out how to apply it. 🙂
yes, it seems it doesn't work (I mean to post it here). Anyway it's uploaded in my profile files, and if you would be so kind, please take a look there! If I would solve this margin analysis, I suppose my boss would love me:) and you too:)
Ah, OK, I see the problem. My mistake. We can't just use Kostprijs that way. Using it that way assumes that everything in the whole data set costs the same amount, which isn't the case. So we need to aggregate costs, not just multiply one cost by the total number of items.
"artcode" identifies the type of item, right?
Frankly, your best option may be to left join the Margin table onto your Main table by artcode, and use this expression:
