Add records by category

Question

Hi community,I have another challenge. I want to add all records of the same category, but first, I need to find which category it belongs to in the description column. When I find it, then I have to add the quantity to the rigth category.How can I do that?Thanks for all your help and support.&nbsp;José Luis&nbsp;

mh2587 · Accepted Answer

measure =&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;=IF(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SUMX(TableName,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FIND(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UPPER(TableName[Category]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UPPER(TableName[Description])&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,,0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ) &gt; 0,&nbsp; &nbsp; &nbsp; SUM(TableName[Quantity]),&nbsp; &nbsp; &nbsp; BLANK()&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp;

Forum Discussion

Add records by category

2 Replies

Related content

Eliminate duplicate records while keeping the most recent record.

Sorting Records

Counting Non-Blank Records

Average of categories over vendor

Filtering Record History by Period