Trying to get this to work with another formula
Sorry Eric for taking so long to get back, but how would I get this to work with another calculation I had to write for dealing with lowering prices based on the quantity the user selects. The formula below is working great:
(abs([Quantity]>0 && [Quantity] <= 23) * ([Price] * [Quantity])) + (abs([Quantity]>23 && [Quantity] <= 47) * ([Price]Range1 * [Quantity])) + (abs(Quantity>47 && [Quantity] <= 131) * ([Price]Range2 * [Quantity])) + (abs(Quantity>131 && [Quantity] <= 199 ) * ([Price]Range3 * [Quantity])) + (abs(Quantity>200 ) * ([Price]Range4 * [Quantity]))
I'm not sure where I plug in the calculation you gave me for dealing with dark colors?