-= Does not work

[Daniel1908]

Hello together, 

the exclusion of -= does not work in the below formula. 
Any Ideas?

=Count(distinct{$-1<[Request]={"x"}>*<[VG]-={7584,2456}>}
If(round([Price1],0.01)>round([Price2],0.01)and[LoadDate]='$(var_Year)',Material,null()))

Kind Regards
Daniel

[Anil_Babu_Samineni]

Can you try this and see?

=Count(distinct{$-1<[Request]={"x"}>*<[VG]-={7584,2456}>}
If(round([Price1],0.01)>round([Price2],0.01)and[LoadDate]='$(var_Year)',Material,null()))

Also, Only this?

=Count(distinct {$-1<[VG]-={7584,2456}>} Material)

[Daniel1908]

$-1<[Request]={"x"} is necessary for the formula. 

But it works without it. 

Any Idea how to get this solved?

[tresesco]

Not sure what you are trying to achieve. May be:

=Count(distinct{$-1(<[Request]={"x"}>*<[VG]-={7584,2456}>)}

[Daniel1908]

This worked

=Count(distinct{-1<[Request]-={"x"}>*<[VG]-={7584,2456}>}

Kind Regards,
Daniel

[tresesco]

So it was a AND/OR combination issue?

[Daniel1908]

I guess this was the problem. 

Thanks for your help. 

Kind Regards, 
Daniel