Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have an expression in which I want to calculate the sum of a field without taking into consideration the null values as follows:
sum (
       {$<
       Type={Sales},
       PeriodDate={"<=$(=vPeriodDate) >=$(=vCurrentYearStart)"},
          Emp_name -= {$(=null())}
       >}
       Sales$HT
       )
however I'm getting error in expression syntax; check attached
sum (
       {$<
       Type={Sales},
       PeriodDate={"<=$(=vPeriodDate) >=$(=vCurrentYearStart)"},
          Emp_name -= {}
       >}
       Sales$HT
       )
hope this helps