topic Re: -= Does not work in App Development

-= Does not work

Daniel1908 — Fri, 16 Apr 2021 15:49:52 GMT

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

Re: -= Does not work

Anil_Babu_Samineni — Fri, 16 Apr 2021 17:31:39 GMT

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)

Re: -= Does not work

Daniel1908 — Mon, 19 Apr 2021 06:44:22 GMT

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

But it works without it.

Any Idea how to get this solved?

Re: -= Does not work

tresB — Mon, 19 Apr 2021 06:52:33 GMT

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

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

Re: -= Does not work

Daniel1908 — Mon, 19 Apr 2021 07:10:47 GMT

This worked

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

Kind Regards,
Daniel

Re: -= Does not work

tresB — Mon, 19 Apr 2021 07:20:40 GMT

So it was a AND/OR combination issue?

Re: -= Does not work

Daniel1908 — Mon, 19 Apr 2021 07:26:31 GMT

I guess this was the problem.

Thanks for your help.

Kind Regards,
Daniel