14 Replies Latest reply: Apr 26, 2011 9:45 AM by Sridhar Ethiraj RSS

    Problem with expression where field is blank

    Gerhard Laubscher


      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])