Referencing a Numeric Line Item Sum in Another Line Item




I have a numeric line item (picture attached) with cells filling in as 1 if they fulfill a condition, 0 if not. The total number of 1s in this example is 1514; I need to reference this total in another line item in a separate module.


This separate module is not dimensioned off of any lists. How can I do this? From what I understand, SUM and SELECT require common list dimensions, is that true or am I mistaken?





Best Answer

  • Misbah
    Answer ✓


    If there is no dimension in your target module, Just refer the count line item of source module. It will automatically pull the top level information. You don’t need any selects and sums here.


    Hope that helps


  • Now I feel silly, didn't realize it was that simple. Thanks!