Forum Discussion

LLT1021's avatar
LLT1021
Helper I
3 years ago

SUMX

Dear all,   I have a question regarding SUMX in relation with memory issues.  I made a small table in which is displayed amount A, an amount B and C=MAX(A-B,0) for key users of a system. These ...
Need Help
LLT1021's avatar
LLT1021
Helper I
3 years ago

Exactly! That's why I created the 'SUM CORRECT' measure, which takes that into account (as you can see in the table), but then I have the problem of memory issues.

 

  • JirkaZ's avatar
    JirkaZ
    Solution Specialist
    3 years ago

    How many records are there in the Employee table?

    • LLT1021's avatar
      LLT1021
      Helper I
      3 years ago

      There are 3150 records in that table.

      • JirkaZ's avatar
        JirkaZ
        Solution Specialist
        3 years ago

        That's not too much to be honest. Your formula should work just fine. Is it failing on the Desktop or in the service as well?