Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I´m trying , using Set Analysis, to filter the information in my table
It´s possible to obtain the sum of the amounts, but only invoices not repeated.
Something like this:
"Sum({$<DISTINCT Invoice>}Amount)"
Invoice Amount
1 15
2 35
3 25
2 35
4 15
4 15
5 40
TOTAL 130
Thanks
sum({<Invoice={"=count(Invoice)=1"}>}Amount)
Try
=Sum( Aggr( Only( Amount), Invoice))
But I would rather remodel the model to avoid the duplicate facts.
Thanks!!!!
It works