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? 

      • LLT1021's avatar
        LLT1021
        Helper I
        3 years ago

        Hmm ok, I just tried also in service and it gives the same problem unfortunately - the visual has exceed the available resources..