Hi everyone,
I’m encountering a frustrating issue with a rental pricing calculation where the same formula produces different results depending on the order of the terms, even though mathematically they’re identical.
I’m working on a fashion rental platform and calculating total price like this:
- Daily price × number of days
- Plus platform fee (5%)
- Plus cleaning fee (fixed)
My expression looks like this:
(AirDate/TimePicker A's end - start: formatted as days)
× Current page's Product's daily price
+
(AirDate/TimePicker A's end - start: formatted as days)
× Current page's Product's daily price × 0.05
+
Current page's Product's cleaning price
This should work. But in practice, I get different totals depending on the order of the elements in the expression — even though the logic is the same.
Has anyone seen this behavior before? Any ideas on how to solve it?