I must still have some CFM language left in my formula as it is still not working.
This TotalPrice Calculation retuns the value of my [ProductCategory] rather than the value related to which quantity the client selects.
Any ideas?
Thanks,
Grant
(((((abs([ProductCategory] == 1 && [Quantity] <= 49)) * [Price]) + ((abs([ProductCategory] == 1 && [Quantity] >= 50 && [Quantity] < 100)) * 1.38) + ((abs([ProductCategory] == 1 && [Quantity] >= 100 && [Quantity] < 200)) * 1.17) + ((abs([ProductCategory] == 1 && [Quantity] >= 200 && [Quantity] < 300)) * .99) + ((abs([ProductCategory] == 1 && [Quantity] >= 300 && [Quantity] < 400)) * .92) + ((abs([ProductCategory] == 1 && [Quantity] >= 400 && [Quantity] < 500)) * .85) + ((abs([ProductCategory] == 1 && [Quantity] >= 500 && [Quantity] < 700)) * .79) + ((abs([ProductCategory] == 1 && [Quantity] >= 700 && [Quantity] < 1000)) * .71) + ((abs([ProductCategory] == 1 && [Quantity] >= 1000 && [Quantity] < 1500)) * .64) + ((abs([ProductCategory] == 1 && [Quantity] >= 1500 && [Quantity] < 2000)) * .61) + ((abs([ProductCategory] == 1 && [Quantity] >= 2000)) * .58)) * [Quantity]) + (((abs(([ProductCategory] == 1) &&([Quantity] <= 99) &&([GH] != 'none' || [GB] != 'none' || [GS1] != 'none' || [GS2] != 'none')))* 5) + ((abs(([ProductCategory] == 1) && ([Quantity] > 99 && [Quantity] <= 199) && ([GH] != 'none' || [GB] != 'none' || [GS1] != 'none' || [GS2] != 'none'))) * 10)+ ((abs(([ProductCategory] == 1) && ([Quantity] > 199 && [Quantity] <= 299) && ([GH] != 'none' || [GB] != 'none' || [GS1] != 'none' || [GS2] != 'none'))) * 15) + ((abs(([ProductCategory] == 1) && ([Quantity] > 299 && [Quantity] <= 399) && ([GH] != 'none' || [GB] != 'none' || [GS1] != 'none' || [GS2] != 'none'))) * 20)+ ((abs(([ProductCategory] == 1) && ([Quantity] > 399 && [Quantity] <= 499) && ([GH] != 'none' || [GB] != 'none' || [GS1] != 'none' || [GS2] != 'none'))) * 25)+ ((abs(([ProductCategory] == 1) && ([Quantity] > 499 && [Quantity] <= 699) && ([GH] != 'none' || [GB] != 'none' || [GS1] != 'none' || [GS2] != 'none'))) * 30)+((abs(([ProductCategory] == 1) && ([Quantity] > 699 && [Quantity] <= 999) && ([GH] != 'none' || [GB] != 'none' || [GS1] != 'none' || [GS2] != 'none'))) * 35)+ ((abs(([ProductCategory] == 1) && ([Quantity] > 999 && [Quantity] <= 1499) && ([GH] != 'none' || [GB] != 'none' || [GS1] != 'none' || [GS2] != 'none'))) * 45)+ ((abs(([ProductCategory] == 1) && ([Quantity] > 1499 && [Quantity] <= 1999) && ([GH] != 'none' || [GB] != 'none' || [GS1] != 'none' || [GS2] != 'none'))) * 55)+((abs(([ProductCategory] == 1) && ([Quantity] > 1999) && ([GH] != 'none' || [GB] != 'none' || [GS1] != 'none' || [GS2] != 'none'))) * 65)) + (((abs(([ProductCategory] == 1) &&([Quantity] <= 99) &&([ENV1] != 'none' || [ENV2] != 'none' || [ENV3] != 'none' || [ENV4] != 'none')))* 5) + ((abs(([ProductCategory] == 1) && ([Quantity] > 99 && [Quantity] <= 199) && ([ENV1] != 'none' || [ENV2] != 'none' || [ENV3] != 'none' || [ENV4] != 'none')))* 10)+ ((abs(([ProductCategory] == 1) && ([Quantity] > 199 && [Quantity] <= 299) && ([ENV1] != 'none' || [ENV2] != 'none' || [ENV3] != 'none' || [ENV4] != 'none')))* 15) + ((abs(([ProductCategory] == 1) && ([Quantity] > 299 && [Quantity] <= 399) && ([ENV1] != 'none' || [ENV2] != 'none' || [ENV3] != 'none' || [ENV4] != 'none'))) * 20)+ ((abs(([ProductCategory] == 1) && ([Quantity] > 399 && [Quantity] <= 499) && ([ENV1] != 'none' || [ENV2] != 'none' || [ENV3] != 'none' || [ENV4] != 'none'))) * 25)+ ((abs(([ProductCategory] == 1) && ([Quantity] > 499 && [Quantity] <= 699) && ([ENV1] != 'none' || [ENV2] != 'none' || [ENV3] != 'none' || [ENV4] != 'none'))) * 30)+((abs(([ProductCategory] == 1) && ([Quantity] > 699 && [Quantity] <= 999) && ([ENV1] != 'none' || [ENV2] != 'none' || [ENV3] != 'none' || [ENV4] != 'none')))* 35)+ ((abs(([ProductCategory] == 1) && ([Quantity] > 999 && [Quantity] <= 1499) && ([ENV1] != 'none' || [ENV2] != 'none' || [ENV3] != 'none' || [ENV4] != 'none')))* 45)+ ((abs(([ProductCategory] == 1) && ([Quantity] > 1499 && [Quantity] <= 1999) && ([ENV1] != 'none' || [ENV2] != 'none' || [ENV3] != 'none' || [ENV4] != 'none'))) * 55)+((abs(([ProductCategory] == 1) && ([Quantity] > 1999) && ([ENV1] != 'none' || [ENV2] != 'none' || [ENV3] != 'none' || [ENV4] != 'none'))) * 65))) || (((abs([ProductCategory] == 11)) * [Price]) * [Quantity]) || ((((abs([ProductCategory] == 2 && [Quantity] <= 1)) * [Price]) + ((abs([ProductCategory] == 2 && [Quantity] >= 2 && [Quantity] < 5)) * 13.50) + ((abs([ProductCategory] == 2 && [Quantity] >= 5 && [Quantity] < 10)) * 12.00) + ((abs([ProductCategory] == 2 && [Quantity] >= 10 && [Quantity] < 20)) * 10.50) + ((abs([ProductCategory] == 2 && [Quantity] >= 20 && [Quantity] < 50)) * 9.00) + ((abs([ProductCategory] == 2 && [Quantity] >= 50 && [Quantity] < 100)) * 7.50) + ((abs([ProductCategory] == 2 && [Quantity] >= 100)) * 6.00)) * [Quantity])