Problema dimensión calculada

[javier1070]

Buenas tardes,

Estoy intentando hacer la siguiente dimensión calculada pero me genera un error, deseo saber si me pueden colaborar de verdad estaría muy agradecido.

if(desc_genero1= ('DESCGENERORow4'),

('DESCGENERORow2'), ('DESCGENERORow3'), ('DESCGENERORow0'), ('DESCGENERORow1') AND match desc_genero= ('Vacio'), ('DESCGENERORow0') AND VLR_RECAUDO <= ('40234'))

[vishsaggi]

May be this? you have conditions with two AND's what is that you want to display if they satisfy, so if conditions satisfied you want something to display right?

for ex: If(yourcondition true, value1, value2) something like that.

= if(Match(desc_genero1, 'DESCGENERORow4', 'DESCGENERORow2', 'DESCGENERORow3',      'DESCGENERORow0', 'DESCGENERORow1') AND

     Match(desc_genero,  'Vacio', 'DESCGENERORow0') AND VLR_RECAUDO <= 40234, Yourexpressions, YourExpr)

OR

= if(Match(desc_genero1, 'DESCGENERORow4', 'DESCGENERORow2', 'DESCGENERORow3',      'DESCGENERORow0', 'DESCGENERORow1') AND

     Match(desc_genero,  'Vacio', 'DESCGENERORow0') AND VLR_RECAUDO <= 40234, Yourexpression)

[vinieme12]

For calculated dimension you need to AGGR() the expression on  a keyfield that identifies each row/ group of data separately.

=AGGR(if(Match(desc_genero1, 'DESCGENERORow4', 'DESCGENERORow2', 'DESCGENERORow3',      'DESCGENERORow0', 'DESCGENERORow1')>0 AND

     Match (desc_genero, 'Void', 'DESCGENERORow0') AND VLR_RECAUDO <= 40234, Yourexpression)

,KEYFIELD)