2 Replies Latest reply: Jan 15, 2014 4:09 AM by jagan mohan rao appala RSS

    if or set analyses

    Tanja Varwijk


      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)