Problem with table which is showing data that makes no sense

Manuel174102 — Wed, 14 Sep 2022 08:14:29 GMT

Hello Everyone,

I have the following problem:

I have a KPI which is showing this : (Sum([Sales_Invoice_Line.Amount])+Sum([Tabelle1.Amount]))

and then I created a small table, which goal is to show a ranking of different sales partners and from which of them how much they should.

The problem is not easy to explain with words, if you open the excel table, you will understand it better.

In the table I used this formulas:

aggr(rank(Sum([Sales_Invoice_Line.Amount])),[Sales_Invoice_Line.Agent Code])

=[Sales_Invoice_Line.Agent Code] (Those r the sale partners)

(Sum([Sales_Invoice_Line.Amount])+Sum([Tabelle1.Amount]))

Thanks in advance

topic Problem with table which is showing data that makes no sense in App Development