Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Hi Tanja,
The syntax for '<>' not equal condition in set analysis is
sum({$<Invoiced-={"0"},Year={"$(=Year(Today()))"}>}Value_SalesAmount)
Use this.
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.