Problem with expression where field is blank

[gerhardl]

Hi,

I have a nar chart with 2 expressions. The first expression shows me the average number of "days since last movement" on the account where the "Transaction Amount" Field is not blank. The second expression should show me the exact same thing, but where the Transaction Amount field IS blank. The first one works 100%, but the second expression returns nothing. Can someone see what is wrong with my second expression?

Expression 1: Avg({1<[Trans Amount]-={} >} [Days since last movement])

Expression 2: Avg({1<[Trans Amount]={} >} [Days since last movement])

Thanks,

G

[gerhardl]

No I'm afraid that also returns nothing...

[lgz]

Hi, How about using len() function? You can try this: avg( {1} [Days since last movement]) ) Hope this helps

[gerhardl · Accepted solution]

I managed to figure it out.

I created a bookmark where all accounts with a transaction are selected. Then I exclude the bookmark in my expression:

Avg ({1-Bookmark01} [Days since last movement])

Thanks for everyone's input. What a mission that was.

Regards,

G

[#5]

Hi,

Try like this way

Normal 0 false false false EN-US X-NONE X-NONE

Normal 0 false false false EN-US X-NONE X-NONE

Avg({$<[Trans Amount]={''=len(Trans Amount)=0"} >} [Days since last movement])

Normal 0 false false false EN-US X-NONE X-NONE

Regards,

Sampath Kumar . G

[#6]

Hi,

Look at the attached application.

If this also doesn't solve the your problem. post the sample data with your required output.

- Sridhar