Problem with grouping lines in table

[#1]

Hello,

I have issue with table object, my tables are related as follows in attached file and the problem is:

When I have Name(CustomerName), SalesId(Or InvoiceId) and CustInvoiceTrans.LineAmount column "CustInvoiceTrans.LineAmount" is showing values correctly, but I need that value to be summed after grouping by name(CustomerName) - I just remove salesId(or InvoiceId) column from table and my table become empty instead of showing summed lineAmount by Name.

Any suggestions?

Thank You in advance!

[#2]

Also i have this expression for LineAmount :

= if (InventBatchId like 'bonus', sum (CustInvoiceTrans.LineAmount))

[mato32188]

try to use aggr function...

example:

dimension: CustomerName

expression: sum(aggr(sum(CustInvoiceTrans.LineAmount), INVOICEID))

[Peter_Cammaert · Accepted solution]

Probably because InventBatchId has a single value per CustomerName/SalesID combination, but if you remove SalesID, every CustomerName will have many InventBatchId values and the IF() will fail (resulting in all NULL values)

Does it work if you change your expression into something like:

=SUM( IF ( InventBatchId LIKE 'bonus', CustInvoiceTrans.LineAmount))

[#5]

Thank You, I think that solve my problem