This content has been marked as final.
Show 5 replies

1. Re: Multiple Calculation Field
mrvodka Sep 10, 2009 8:10 AM (in response to mgxdigital)unit price * qty / Case ( unit type = "msi"; 1000; 1 )

2. Re: Multiple Calculation Field
mgxdigital Sep 10, 2009 11:31 AM (in response to mgxdigital)Is there a way to do the same exact thing, but when the choice is msi make the equation:
MSI = unit price / 1000 * (field::width) * 12 * qty

3. Re: Multiple Calculation Field
mrvodka Sep 10, 2009 11:39 AM (in response to mgxdigital)Sure we can tweak the calc all day but you are now changing the parameters of what the calc was supposed to do as per your orig post.
What exactly should be happening for all 3 scenarios.

4. Re: Multiple Calculation Field
mgxdigital Sep 10, 2009 12:00 PM (in response to mgxdigital)Extended Total =
If the unit price is "msi" then take the unit price divided by 1000 * width * 12 * qty
If the unit price is "feet" then take the unit price times the qty.
And if the unit price is "sheets" then take the unit price times the qty.

5. Re: Multiple Calculation Field
mrvodka Sep 10, 2009 4:22 PM (in response to mgxdigital)unit price * qty * Case ( unit type = "msi"; 12/1000 * width; 1 )OR
unit price * qty * Case ( unit type = "msi"; .012 * width; 1 )
Edit: Added second choice which further simplifies