Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How would you perform this, let's see if I can explain myself properly. But I have a table with a valueName and Amount and then an Invoice column calculated by these two.
My goal is as below
So for example:
Client Value Amount Invoice
ClientA Milk 100 150
ClientB Milk 100 175
ClientC Butter 15 25
The factor here for any particular client with a specific Value I want to be able to set, change, update.
How would you do this?
Cheers
Not sure I really grasp what you are trying to achieve.
I think the answer is no, but maybe you could clarify your needs ?
So basically a smart way making the invoice value. so for clientA when he buys milk charge Amount*1,5 and the same for ClientB but charge Amount*1,75 e.g.
I would think about creating this extra data externally - a spreadsheet for quick & dirty or a database for a robust solution. But where would you get the values from ? They may well already be stored on some database.
Then you can load this data into your data model as well, join it on Client and from there on it should be plain sailing