Calculation using division
Im trying to get a percentage from a calculation field. Qty Produced / Qty Expected.
My calculation of Qty Produced - Qty Expected works just fine, however the division gives me the same result.
Qty Produced is a summary field and Qty Expected is a straight number field.
They are in separate tables.
Any thoughts?
The expression Qty Produced / Qty Expected is exactly the expression that you should be using for division. If it is not producing the expected result, you'll need to investigate and see what values are being returned by the two fields when this calculation evaluates.
Note that summary fields return very different values depending on the context in which they evaluate.