if ATTR([DB1.[Amount]) = ATTR([Amount]) then "TRUE"
Thank you very much for your answer. But this is just working when I have only one entry in a table.
But my mistake. There are Customers which ordered under one Transaction multiple orders. This is why I used first the SUM of Customer ID
can you post some workbook with fake data?
hope it works. But in this example the problem is not coming up. Maybe its something in my database.
If I keep a line that was wrong, it's true again.
Customer ID Opp Id Amount AB 1 10 CA 2 33 CA 3 13 CA 4 48 ZU 5 65 HU 6 32 IJ 7 7 IJ 8 546 IJ 9 234 KL 10 7 KL 11 87 AB 12 34 CD 13 123 AA 14
Customer ID Amount AB 10 CA 94 ZU 65 HU 32 IJ 787 KL 94 AB 34 CD 123 AA 45
Mappe1.twbx 28.5 KB
yes it's also working for me. But I can not extract the issue into example data. Its something with my datasource or pre joint stuff where a calc error showing up. When I exclude some Customers other get false or true. So it's something in my filter maybe.
But thank you all.