Show values with codition is null

[#1]

I want to display values with condition column 'Hors Vente' = - (Null)

Thx in advance

[sunny_talwar]

Is equal to null or is not Equal to null???

Is Equal to null:

{<[Hors Vente] = {"$(=Len(Trim([Hors Vente])) = 0)"}>}

Is not Equal to Null:

{<[Hors Vente] = {"$(=Len(Trim([Hors Vente])) > 0)"}>}

[teiswamsler]

Hi Stanley

Inn the script you can use isnull() statement to flag out tranactions with ( - )

/Teis

[kuczynska]

You can always assign your own value to NULLs in your load script:

NullAsValue *; //you can always predefine the set of fields you want to populate with nulls, in my case it's all fields, you can only mention [Horse vente] field of course.
Set NullValue = 'MyOwnNULLValue';  //this can be defaulted to numerical/alphanumerical value, depends on what you want to achieve

After this it should be easier for you to filter for values, exclude/include your nulls or simply use some Set analysis to ignore null values from your sum/count.

[#5]

Hi

In scripting you can write like below

if(isNull([Hors Vente]),'Give Ur Value',[Hors Vente]) as [Hors Vente]

the above script will fill your null values with your own data

[#6]

I just want something like this in calculated dimension:

[#7]

Hi Teis. Thx for the answer... I'm just looking for something like this in calculated dimension:

Thx in advance

[Kushal_Chawda]

create calculated dimension as

if( Isnull([Hors Vente]) or len(trim([Hors Vente]))<=0, 'Null',[Hors Vente])

[#9]

It's not goog. Th result:

I want to show values with condition 'Hors vente' = Null or -

[Kushal_Chawda]

You want to show some values where Hors Vente is null , is that what you are looking for?