Expression does not work

[phil_asmar]

Dear All,

Why does this not work:

if(

  count(EXECUTION_PLANNING_NAME1)>0 and IsNull(EXECUTION_PLANNING_NAME2),

  EXECUTION_PLANNING_NAME2,EXECUTION_PLANNING_NAME3

)

while this works:

if(

  count(EXECUTION_PLANNING_NAME1)>0 and IsNull(EXECUTION_PLANNING_NAME2),

  1,0

)

PS:EXECUTION_PLANNING_NAME2 AND EXECUTION_PLANNING_NAME3 ARE ATTRIBUTES AND NOT TEXT.

Thank you

[Kushal_Chawda]

try

if(

  count(EXECUTION_PLANNING_NAME1)>0 and IsNull(EXECUTION_PLANNING_NAME2),

  EXECUTION_PLANNING_NAME1,EXECUTION_PLANNING_NAME3

)

[Anonymous]

what is the Output?

in first Expression EXECUTION_PLANNING_NAME2 might be null and so in a table "-" would be displayed,

while in second Expression "1" would be displayed

WHat do you mean "does not work"

[PrashantSangle]

Hi,

what do you want to do with EXECUTION_PLANNING_NAME2,EXECUTION_PLANNING_NAME3

do you want to sum it or count of it

write sum(

if(

  count(EXECUTION_PLANNING_NAME1)>0 and IsNull(EXECUTION_PLANNING_NAME2),

  EXECUTION_PLANNING_NAME2,EXECUTION_PLANNING_NAME3

)

)

Regards

[phil_asmar]

This is a listbox so when i put EXECUTION_PLANNING_NAME2, I WANT IT'S VALUES. I dont want to count or sum. Just the values inside EXECUTION_PLANNING_NAME2 as a list.

[PrashantSangle]

Hi,

also check your condition when

Condition count(EXECUTION_PLANNING_NAME1)>0 and IsNull(EXECUTION_PLANNING_NAME2) is true

then you are showing EXECUTION_PLANNING_NAME2 which is null

then you will get blank or - .

Regards

[engishfaque]

Dear Phil,

Please check this one,

=if(count (Len(Trim(EXECUTION_PLANNING_NAME1)))>0 and EXECUTION_PLANNING_NAME2 = '', EXECUTION_PLANNING_NAME2, EXECUTION_PLANNING_NAME3)

Please note, have you checked values in listed above fields 1, 2, and 3?

Kind regards,

Ishfaque Ahmed

[hic]

Your expression contains naked field references, i.e. field references that are not wrapped in aggregation functions. This will cause problems.

See Use Aggregation Functions!

HIC

[phil_asmar]

EXECUTION_PLANNING_NAME1 and EXECUTION_PLANNING_NAME2 and EXECUTION_PLANNING_NAME3

all have values and are not null.

At any case, the if statement is either true or false so in any case it should return a dimension.

That is the problem, it is not returning anything!

[phil_asmar]

i think that is my problem, but i dont want to use any of the sum or other aggregation functions. I only want to display all the attributes inside the dimension.

How would i do that?