Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
there are two columns:
column: group (some cells with value, but some without value and is null)
column: amount (numbers)
now want to sum the amount for group which the value is not null,
how to write the chart formula?
I tried like this but failed:
sum({isnull(group)=-1}amount)
Perhaps with Sum(IF()) expression or Set Analysis like this
Sum(IF(Not IsNull(group),amount))
or
Sum({$<group={"=Len(Trim(group))=0"}>} amount)
Perhaps with Sum(IF()) expression or Set Analysis like this
Sum(IF(Not IsNull(group),amount))
or
Sum({$<group={"=Len(Trim(group))=0"}>} amount)
Thanks so much!