Forum Discussion

LLT1021's avatar
LLT1021
Icon for Helper I rankHelper 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
JirkaZ's avatar
JirkaZ
Icon for Solution Specialist rankSolution Specialist
3 years ago

How many records are there in the Employee table?

LLT1021's avatar
LLT1021
Icon for Helper I rankHelper I
3 years ago

There are 3150 records in that table.

  • JirkaZ's avatar
    JirkaZ
    Icon for Solution Specialist rankSolution 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
      Icon for Helper I rankHelper 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.. 

      • JirkaZ's avatar
        JirkaZ
        Icon for Solution Specialist rankSolution Specialist
        3 years ago

        Might be related to how the measures A and B are defined then.