IF

[fmazzarelli]

Hi Community

I wish to make a kpi but the misure returns the value 0.

Could you help me?

IF ((CTRAAN = 'N' OR CTRAAN = ' '), sum({<Commessa = {'ASSTEL'}>} [TotOreLavorate]), 0)

Thanks in advance

[chriscammers]

Does this work?

sum({<CTRAAN = {'N',' '},Commessa = {'ASSTEL'}>} [TotOreLavorate])

[#3]

sum({<CTRAAN = {'N',""},Commessa = {'ASSTEL'}>} [TotOreLavorate])

[MindaugasBacius]

=sum({<
  CTRAAN = {"N",""}
  ,Commessa = {"ASSTEL"}
>}TotOreLavoarate)

Set Analysis works fine. Unfortunately I couldn't manage to make the space mark in Inline load so have written CTRAAN = {"N", ""}N","."}

[chriscammers]

Personally I don't like to leave nulls or blanks in my table data, it tends to make selections and Set Analysis more difficult. I would recommend backfilling blanks with a word and then the nulls with something else.

You'd want to do this in your load.

The advantage to doing this is that if you see nulls in your charts then you know that you may have a relationship problem that may need to be addressed. I'm just considering missing rows in associated tables.