Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts
I try to multiply two values in an app.
Sum([Total Order Quantity] * [time in hours])
Total Order Quantity for example has the value 5.
Time in hours has the value: 3
Result should be 15, but the app shows zero. Therefore this formula is not working. Where is the problem?
Thank you.
Tom
just solved: Sum([Time in hours]) * sum([Total Order Quantity])
We have no way of knowing what the problem is based on this. Could you include a sample app, or share the schema?
Difficult to guess without an example, it could be nulls, wrong format in your data, non-associated fields, syntax error, etc.
JG
just solved: Sum([Time in hours]) * sum([Total Order Quantity])