Hi all
how to create formula in power query to auto follow each level rebate calculate
example
jack is VIP1, he buy 90unit iphone xs total 89,910.00
VIP 1 rebate is 0.25%,if 89,910.00 multiplication 0.25%,he can get 224.78, But there is a limit for cash back which is 150 only for VIP 1 。
pls refer example
Thanks
how to create formula in power query to auto follow each level rebate calculate
example
jack is VIP1, he buy 90unit iphone xs total 89,910.00
VIP 1 rebate is 0.25%,if 89,910.00 multiplication 0.25%,he can get 224.78, But there is a limit for cash back which is 150 only for VIP 1 。
pls refer example
Thanks