topic Re: Hiding rows in a flat table where two values are not equal in App Development

Hiding rows in a flat table where two values are not equal

elijahabel — Sat, 16 Nov 2024 21:49:29 GMT

I'm working on a problem where we need to check where values from different environments do not align.

I have a flat table with the below columns

UAT.Division | Prod.Division | Sum(UAT.Value) | Sum(Prod.Value)

I want to only show the rows where Sum(UAT.Value) <> Sum(Prod.Value).

How can I accomplish this? Thank you!

Re: Hiding rows in a flat table where two values are not equal

JustinDallas — Tue, 27 Nov 2018 15:51:39 GMT

Hmmm, generally, you can use an "If" statement in the Dimension declaration. But the problem here is that you have the aggregate function (Sum) as your criteria, and QS isn't going to like that. I'm interested in what the solution you settle on will be.