Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, every body,
I have 2 fields,
Table 1:
Material_Estructuras
Table 2:
Material_Rutas
I want to sum sales only of the registers from the field "Material_Rutas" that are also in the field "Material_Estructuras"
How could I place an "IF" condition ?
Thanks!!
I'm unclear what you're asking for. If you want a chart expression, maybe this?
sum({<Material_Rutas*=P(Material_Estructuras)>} Sales)
Hi John thanks for your quick answer,
I have 2 tables, all my registers from my field "Material_Estructuras" are into the field "Material_Rutas" I need to sum their values but just the ones that are into the field "Material_Rutas".
Table 1:
Material_Estructuras
Table 2:
Material_Rutas
Hi javierortiz,
Have you tried to use John's proposed solution? Logically it should work with "*" and P(). In Set Analysis "*" refers to intersection and P() refers to Possible Values.
Please post an example if the above expression does not work.
Good luck and have a good weekend.
Cheers - DV
Hi DV I used john´s expresion but the totals did not match, I posted the app, could you guys please check it out and see if something is wrong even with the Data Model?
I really appreciate your time and help.
Thanks!!
Hi javierortiz,
I am using personal edition at home. I'll look into this tomorrow (Monday) at work. Meanwhile, if John or others can help, that will be great.
Cheers - DV
I don't know what numbers you want to see. All I know is that you don't want what I gave you (it returns 0). That's not much information. I can't help you.