Forum Discussion

Svante109's avatar
Svante109
Frequent Visitor
5 years ago
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....
Need Help
  • Svante109's avatar
    Svante109
    5 years ago

    I managed to find the solution myself. The issue was with rounding the numbers throughout the report, and not the formulas. 

Geradav's avatar
Geradav
Responsive Resident
5 years ago

Svante109  I think you need to help us help you a little. Give us an example of the output you would expect.
What do you consider past period, current period, and future period?
Is the current period the current month in which we are today? So, today's current period is January?

  • Svante109's avatar
    Svante109
    Frequent Visitor
    5 years ago

    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. 

    • Geradav's avatar
      Geradav
      Responsive Resident
      5 years ago

      ok thanks for the clarification