Dynamic factor by client

[#1]

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

[Anonymous]

Not sure I really grasp what you are trying to achieve. 

I think the answer is no, but maybe you could clarify your needs ?

[#3]

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.

[Anonymous]

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