if or set analyses

[tanjavarwijk]

Why do I become different answers, the If is right but I want to use the other

(if(Invoiced<>0 and Year=($(=Year(Today()))),Value_SalesAmount))



//Sum({<Invoiced={'<>0'},Year={$(=Year(Today()))}>}Value_SalesAmount)

[jvishnuram]

Hi Tanja,

The syntax for '<>' not equal condition in set analysis is

sum({$<Invoiced-={"0"},Year={"$(=Year(Today()))"}>}Value_SalesAmount)

Use this.

[jagan]

Hi,

Check this expression, you need to use -= to exclude the values instead of <>

Sum({<Invoiced-={'0'},Year={$(=Year(Today()))}>}Value_SalesAmount)

Hope it helps you.

Regards,

Jagan.