Compare different values with filter applicated

[angelsore]

Hi all,

I'm trying to create a variable OK/ERROR that depends if one of the values in one table is equal to another value with the same filter then should put OK. If none match then it should put ERROR. This is my data example:

And it should be like:

For each OTR, if Gu.Denominacion=RegistroLWL.A1 then all this OTR OK. If not then ERROR.

Thanks!!!

[lfetensini · Accepted solution]

a) Remove Columns: GU.Denominación and RegistroLWL.A1 from the table;

b) Use this expression:

If(
 Aggr(
  Sum(
   If(
    DENO=REG,
    1)
  ), OTR) > 0,
'OK',
'ERROR')

[angelsore]

It's exactly what I was looking for!!!

Thank you so much!