matt, try Math([Number Plays] + [skip count])

or with the ,0 you will see. i guess you did skip some songs..

i only had some skip counts that gave me 0 when using only [skip count,0] in a expression the rest was empty, and that is where it goes wrong.

gab

Thanks. I can reproduce it. It's a little tricky.

Numeric fields can return empty strings if they're blank or zero (we don't tightly differentiate zero / empty cases due to intentionally loose typing in the database engine).

The operator precedence gives evaluation like this:

Start with:

Math([Number Plays] + [Skip Count])

Evaluate pieces inside function:

Math(4 + )

Evaluate function:

0 (because math parser is confused)

The math parser doesn't understand '4 +'

To make sure you're feeding valid math to the math parser, use this instead:

Math(FormatNumber([Number Plays]) + FormatNumber([Skip Count]))