expression is not working in straight table? please help

[#1]

Hi,

I have below expression in straight table

expression 1=IF(ISNULL(Amount)=0,Amount,Amount) --- not working

when I used this the data is not showing in columns. when I used Amount in list box it is showing blanks at the top.

I have used the expression 2 with different column name as below which is working fine.

expression 1=IF(ISNULL(SalesAmount)=0,SalesAmount,SalesAmount)   --- working fine

Only expression 1 is not working.

Please can anyone suggest me is there any wrong in expression 1?

Thanks.

[swuehl]

An expression should be conctructed using aggregations functions like sum() etc.

If you don't do that, your expressions return NULL when there is not a single, unambiguous result.

In your expression, if field Amount has more than one possible values in the context of current selections and dimensions, you won't get a result.

And why are your THEN and ELSE branch identical?

[#3]

I have tried below not working

=Sum(Amount)

please help me how to change the above expression?

[swuehl]

What do you mean 'not working'?

No result ('-'), zero or wrong result (based on what definition of wrong)?

Have you checked that your values in field Amount are numbers, not text values?

[PrashantSangle]

Hi,

Try this

Sum(If(len(trim(Amount))=0 or isnull(Amount),Amount,Amount))

Regards

[hariprasadqv]

Hi,

ISNULL returns TRUE or FALSE. Instead of that you can use NULLCOUNT().

[#7]

Thanks. I found the problem. I have added in script in link table as below

'' as Amount

I believe that caused the problem.

now I removed it and can able to see values in column.

[#8]

Thanks.

[#9]

Thanks.