Hello.
I want to make a list in a PDF where only the rows that are duplicates of the [AMOUNT] column appear.
That is, the rows with duplicate [AMOUNT].
The structure of the table is:
[IDFRA]
[CONCEPT]
[AMOUNT]
Can you help me?
Thank you!!!
Solved! Go to Solution.
Use a START expression with a formula such as:
FILTER( table ,
ISNOTBLANK( FILTER( table ,
AND( [amount] = [_THISROW-1].[amount] , [id]<>[_THISROW-1] )
) )
)
Use a START expression with a formula such as:
FILTER( table ,
ISNOTBLANK( FILTER( table ,
AND( [amount] = [_THISROW-1].[amount] , [id]<>[_THISROW-1] )
) )
)
Thank you.
I have tried and the list appears blank.
It does not return any records.
Oops, I must have had a brain fart while writing the formula I was thinking of. Just updated it in my first comment.
AWESOME !!!
Thanks a lot!!!
Works!!!!!!!!
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |