Customer A
(4.00)
Customer B
(4.00)
Customer C
(4.00)
Customer D
(4.00)
Customer E
(4.00)
Customer A
1
2.0%
2.0%
4.0%
2.0%
5.0%
2.0%
Customer B
2
2.0%
25.0%
4.0%
25.0%
5.0%
25.0%
Customer C
1
2.0%
3.0%
4.0%
3.0%
5.0%
3.0%
Customer D
2.0%
4.0%
5.0%
Customer E
3
2.0%
2.0%
4.0%
4.0%
5.0%
5.0%
"Name","Price Condition","Price Increase 1","Condition Rate 1","Price Increase 2","Condition Rate 2","Price Increase 3","Condition Rate 3"
True
True
True
False
False
False
False
False
False
upper
Price Increase 1 = REGEX_Replace([Price Increase 1], "[%.00]", "")
Condition Rat...
"Name","Price Condition","Price Increase 1","Condition Rate 1","Price Increase 2","Condition Rate 2","Price Increase 3","Condition Rate 3"
False
True
True
False
False
False
False
False
False
upper
New Price 1 = [Current Price] * (1 + ([Price Increase 1]/100))
New Price 2 = [Cu...
Horizontal
Solution