topic Re: To sum up Value only those where its Null in App Development

To sum up Value only those where its Null

Applicable88 — Fri, 30 Oct 2020 15:22:24 GMT

Hello,

I have two tables associated via Datamanager.

I want to sum up a value with following condition:

sum({1<Month1={"$(=Num(Month(Today())))"},Year1={"$(=year(Today()))"}>}[Sales])

I want to add one more condition: only where its Null()

So I tried this:

sum({1<Month1={"$(=Num(Month(Today())))"},Year1={"$(=year(Today()))"},ProfitNO={"Null()"}>}[Sales])

or this:

sum({1<Month1={"$(=Num(Month(Today())))"},Year1={"$(=year(Today()))"},isNull(ProfitNO)}>}[Sales])

I also try to give those fields where its null a new name in the load script so I can make simpler set expression:

is(isnull(ProfitNO), 'NEWNAME', ProfitNO)

But it still shows me all value as "-"

I hope someone has an idea.

Thank you very much in advance.

Best.

dplr-rn — Fri, 30 Oct 2020 15:48:06 GMT

instead of isnull try len(ProfitNO)=0

MayilVahanan — Fri, 30 Oct 2020 16:15:58 GMT

Try like below

If(isnull(ProfitNO) or Len(Trim(ProfitNO))=0, 'NEWNAME', ProfitNO) as FieldName

Applicable88 — Fri, 30 Oct 2020 22:33:23 GMT

thank you very so far. I tried both not working.

But after I used "nullcount()=0" in a set expression it works out. Can you explain why len(trim)) and isNull not returning the same?

Thank you .

Best.