Hi guys,
I am back for more assistance,
This time working on a list with pricing.
I categorize percentages into ID codes, for example:
ID code "1"= 40%
ID code "2" = 30%
ID code "3" = 20%
ID code "4" = 10%
I have a table that is divided into ID, Price and Discounted price.
What I am trying to do is essentially:
If "ID"= 1, then {List Price * 40%}
If "ID"= 2, then {List Price * 30%}
And so forth...
I have an idea of how to tackle it, but my main issue is defining the variable "1" as 40%.
I would appreciate your assistance.
Have a great day
I am back for more assistance,
This time working on a list with pricing.
I categorize percentages into ID codes, for example:
ID code "1"= 40%
ID code "2" = 30%
ID code "3" = 20%
ID code "4" = 10%
I have a table that is divided into ID, Price and Discounted price.
What I am trying to do is essentially:
If "ID"= 1, then {List Price * 40%}
If "ID"= 2, then {List Price * 30%}
And so forth...
I have an idea of how to tackle it, but my main issue is defining the variable "1" as 40%.
I would appreciate your assistance.
Have a great day