Set Analysis question

[#1]

Hello,

Can anyone help me with this expression?

The first part of the expression is ok, the problem is the second part after the multiplication sign.

I want = Tqte * Pontos_FT but only 700 | 0009 reference Pontos_FT

Thanks

Rodrigo

if(Dt_fase_Retorno < '0', sum ({$<Fase={'RISCO'}>} {$<Oficina={'MW-RISCO'}>} TQte

*

({$<Material_detail_id ={'700 | 0009'}>} Pontos_FT)))

[Miguel_Angel_Baeyens]

Hello Rodrigo,

According to the set analysis syntax, something like the following should work

Sum({< Fase = {'RISCO'}, Oficina = {'MW-RISCO'}, Dt_fase_Retorno = {"<0"} >} TQte) * Sum({< Material_detail_id = {700, 0009} >} Pontos_FT)

Hope that helps

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[#3]

Hi Miguel,

Thanks for reply. But didn't work. Returned zero for all lines.

I need to multiply line by line like the expression below...

sum (TQte * Pontos_FT)

Not like the expression below...

sum (TQte) * sum(Pontos_FT)

Did you get it?

Regards,

Rodrigo