Forum Discussion
Solved
SUMX Calculating wrongly
I am working on a report the is supposed to show invoices and how they impact past, current and future periods. This is done on a calendar month to month basis. All calculations are done by measures....
I managed to find the solution myself. The issue was with rounding the numbers throughout the report, and not the formulas.
The past period, is anytime that is before the start of the current month
The Current period is the current month
The Future period is any time after the end of the current month.
In the top line, I would expect an outcome of past period of 237.034,00 (as that is the total amount), but am getting an output of 236.826,00.
ok thanks for the clarification