Exclude selecction in TOTAL expression

[francis_gr]

Hi!!

I have this expression sum({$<ID_Prod=>}Total Sales, but when i do a selecion from ID_Prod field, affects the results of the expression.

What am I doing wring?

Regards

[Frank_Hartmann]

try this:

sum({1<ID_Prod=>}Total Sales)

[tresesco · Accepted solution]

Ideally, it should not. However, I guess your real expression might not be exactly the same, and you perhaps simplified the expression to post thinking it would be similar. Could you please post the exact same expression that is there in the actual app? Or may be a sample app that demonstrates the issue?

[francis_gr]

Hi Frank!

Thanks for your reply, I have tried your expresion but the problem persist.

Can be there another solution?

I'm going to attach an example

Regards

[francis_gr]

Hi Tresesco:

You're right. It's a simplified expression. I'm going to prepare a sample file.

Thanks for your reply.

Regards

[francis_gr]

Hi Tresesco:

While I was preparing my example, I have seen what was wrong. In my expresion, sales is a variable, and i had not put the  exclusion in the variable expresion.

Thanks for lending to help me.

Regards

[francis_gr]

Hi Frank:

As I said to Tresesco, while i was preparing the sample file, I´ve seen what was wrong. In my expresion, sales is a variable, and i had not put the  exclusion in the variable expresion.

Thanks for trying to help me.

Regards