Hello Pigment community,
I have a list of different clients that depending on the amount of users they are charged a different price based on tiers. Currently we do the process with an excel model that calculates the total price of the subscription based on a table that looks like this with the IFS formula:
I would like to do this automatically on Pigment but I don’t know how to set it up so that based on the amount of users it multiplies such user for the correct price. Another limitation is that as you can see in the table there is the price of the Core service, and then there are different options that the clients can subscribe to. Therefore I also need pigment to multiply the usage by the correct options depending on what options each client has subscribed to. Currently in excel we do it by the means of this table:
As you can see we use 1 as true and 0 as false.
Thank you in advance,
Gabriel
