Need Help on Expressions and Dimension

[#1]

Hi,

Dimension is : Gender

Expression: Count(members)

The problem is Gender has values like M,F,-,Null.

I have to combine the values for "-" and "Null" i,e 1179+4 should be my total count for unknown Gender.

My output should be something like

Unknown:1179+4(1183)

Male:1218

Female:3222

    

Any suggestions please

[kaushiknsolanki]

Hi,

     Try this calculated expression.

     If(istext(Gender),Gender),null())

Regards,

Kaushik Solanki

[tresesco · Accepted solution]

Use calculated dimension something like:

If(IsNull(Gender) or Gender='Null' or Gender='-', 'Unknown' , Gender)

[salto]

Hello,

or maybe this other one as well:

if(isnull(Gender),'Gender is Null', Gender) as Gender

Hope this helps.

[Anonymous]

Poornima

You take Kuausik's suggested expression back to the load script and do something like:

     If ( istext ( Gender), Gender , 'Unknown' )     as Gender

Best Regards,     Bill