My understanding of the Switch() function is that it will return the first true value from the expression. Which doesn't really help me.
What I'm trying to do is calculate the CoreWeight field based on the product type. They are different because of the thickness of the material used to make the core for each product. Hence dividing the Roll Length by the stated values.
So as an example:
If the product type is Roll Towel then the calculation for the core weight is the roll length divided by 10.2
As stated this calculation will be different if the product type is different.
I hope my explanation is clear enough.
Any more ideas.
All of the above offerings provide hard-wired solutions to your problem. You might like to consider creating a lookup table with two fields, ProductType and CoreWeight. Your formula can use the DLookup function to retrieve the core weight corresponding to the product type. There are two advantages to this method. One is that you can add new product types without messing about with the formulas. The other is that if you change the core weight at any time, you can access either the old or new values (for historic reporting) by adding a date range to the lookup table.