Expresion

[smilingjohn]

HI all,

Iam trying to write a expresion  for the below given requirement ...please suggest if it is coorect

i have to take the coount of column A if there is null then it should take the count of Column B else Column A

count (isNull( A,B)A)

Please correct

[devarasu07 · Accepted solution]

Try like below,

count(if(isnull(A),B,A))

or

IF(LEN(TRIM(A))<0,A,B)

[tresesco]

Not sure what you are trying. The correct syntax would be: =Count( If(Isnull(A),B,A))

[Kushal_Chawda]

try this

=count(Alt(A,B))

[tresesco]

Alt() would fail if A, B have non-numeric values.

[tresesco]

IF(LEN(TRIM(A))<0,A,B) - len() never returns a negative value. I guess it's a typo. It would be '>'.

[Kushal_Chawda]

Yup, correct