Forum Discussion

JNelson's avatar
JNelson
Icon for Helper II rankHelper II
2 years ago
Solved

Summarising rows based on other columns

Hello!

 

I need to summarise one of my columns [Qty] based on the other columns in the table.

If Tr and Type are blank, and if Date and Job No are the same, I need the Qty to sum and the populated Tr and Type to align with the summed amount, producing one single row for that entry.

 

Is this possible?

 

 

Thank you!

Need Help

9 Replies

    • JNelson's avatar
      JNelson
      Icon for Helper II rankHelper II
      2 years ago

      Thanks for your reply. I don't really know how to apply this to my current data set/tables. Do you have any commentary that explains what is happening?

      Thanks

      • ryan_mayu's avatar
        ryan_mayu
        Icon for Super User rankSuper User
        2 years ago

        separate the table, one includes the data without null type. another includes the data with null type. 

        Then group by the second table. At last, combine two tables