Forum Discussion

MorganKlaif's avatar
MorganKlaif
Helper I
2 years ago
Solved

Matrix - Non Summed Value?

Hello,   I'm working on a report and I'm having difficulty trying to get the correct amount to be used. The report is using a matrix view. I'm trying to show the capacity of some activities and the...
Need Help
  • MorganKlaif's avatar
    MorganKlaif
    2 years ago

    This has been resolved.

     

    After looking up how the merge functions, and knowing that I used a LEFT OUTER join, I found out that I needed to enable load on my ACTIVITIES table, create a relationship with the MERGED table based on ACTIVITY_ID, which is what I used for the join, and I was able to use the ENROLLMAX from ACTIVITIES directly to correctly SUM, rather than multiply.

MorganKlaif's avatar
MorganKlaif
Helper I
2 years ago

This has been resolved.

 

After looking up how the merge functions, and knowing that I used a LEFT OUTER join, I found out that I needed to enable load on my ACTIVITIES table, create a relationship with the MERGED table based on ACTIVITY_ID, which is what I used for the join, and I was able to use the ENROLLMAX from ACTIVITIES directly to correctly SUM, rather than multiply.