Forum Discussion
Multiplying calculated column values
- 9 years ago
Would you mind sharing the formulas used to calculate Price and Quantity? Multiplying two calculated columns should not give you an error by itself.
In any case, you can try using variables for the Result column, like so:
Result = VAR PriceVar = (your Price column formula goes here) VAR QuantityVar = (your Quantity column formula goes here) RETURN PriceVar * QuantityVar
This way, the Result column will not depend on either Quantity or Price columns, so if you don't strictly need them, you can get rid of them and save memory.
Would you mind sharing the formulas used to calculate Price and Quantity? Multiplying two calculated columns should not give you an error by itself.
In any case, you can try using variables for the Result column, like so:
Result = VAR PriceVar = (your Price column formula goes here) VAR QuantityVar = (your Quantity column formula goes here) RETURN PriceVar * QuantityVar
This way, the Result column will not depend on either Quantity or Price columns, so if you don't strictly need them, you can get rid of them and save memory.