I have a puzzling question... puzzling for me that is... I'm hoping one of you geniuses out there can help...
I need to know how to accomplish this set of calculations. I have tried using the Case function, but it doesn't like what I'm typing...
I need to calculate a % on total sales on a sliding scale... Here's everything I'm needing to accomplish and wanted it in one field... but perhaps I need to create multiple fields to accomplish this? Thanks in advance!
If TotalSalesYTD are under $2000 I need to multiply TotalSalesYTD by 2%.
If TotalSalesYTD are over $2000 but under $4000, I need to calculate the amount of TotalSalesYTD over $2000 but under $4000 TotalSalesYTD and multiply that difference by a rate of 1%.
If TotalSalesYTD are over $4000 I need to calculate the amount over 4000 and then the rate would be at 0%