Using something similar to Vlookup

Question

Dear Community,

I have a transaction list in which I want to add a percentage based on a dimension I have, but I get the sum of the all the percentages in every line.

I want to do what would be a simple VLook up in excel from the following dimension:

If you have any guidance or any idea how to do that on Pigment it would really help me. My end goal is to have each amount that is on every line multiplied by a percentage based on the dimension name of the offer.

Thank you very much in advance!

Jose

francois · Accepted Answer

It seems like you’re typing your formula in the property ABO-Pres and not in Percentage, which is why you have this error.

Nathan · Answer

Hi Jose,It is as simple as in excel:‘Orange Offer’.Percentage[By:’Transaction list’.’property with orange offer dimension’]Howeverit can be accessed in another way in Pigment, simpler in some ways:’Transaction list’.’property with orange offer dimension’.Percentageso Most likely:’Transaction list’.ABO-Pres’.Percentage