Is it Possible to create a column in Variable Pay that can distinguish between Percentage and Money?

[juanantonioga]

Hi Colleagues,

I'm facing a proyect where the client have a business goal that reflects a percentage. However, we have created custom columns to reflect the right money symbol for the minimum, target, maximum, obtained....

The thing is that in those columns I cannot have the business goal that show us the % symbol... Here is a screenshot for more information:

Is there a workaround? Thanks a lot, all the ideas are welcome guys!

@xavierlegarrec 

[xavierlegarrec · Accepted solution]

Hi @juanantonioga 

It should be based on this screenshot I just took in my demo environment : 

Can you share whether these columns are standard or custom ? The ones in my screenshot above are the standard ones.

I think yours might be custom, in which case all you have to do is to switch them to type=Percent

All the best,

Xavier

[juanantonioga · Accepted solution]

Hi Xavier,

First of all, thanks for your help. Regarding those columns they are custom, because the standard ones as you already shared they are not showing any symbol. I had to great custom ones and reference the standard in order to get the right symbol, the thing is that ALL the business goals are in euros but one that is in percentage. My question is is there any way that we can configure a custom column so that column can differentiate between euros and % (when the column read something display the value in % if not in euros).

Thanks a lot Xavier!

[xavierlegarrec · Accepted solution]

No unfortunately that is not possible. @juanantonioga 

[xavierlegarrec · Accepted solution]

What I would do is turn these columns from your screenshot into Amount so that there is never any sign in front of it, then I would add a custom column next to the business goal name with a lookup table with attribute = busgoalname where I add in plain text whether the values that come next are Percentages or Money. @juanantonioga