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