I am trying to create a calculated field based on my webform data that I have made available in views using MySQL views and Data modules. I have a number value that I want to manipulate in other columns but I always get zero if I try to use a replacement pattern, however these fields appear before the global math field and their replacement patterns indicate they are available for use. Any ideas?

Comments

merlinofchaos’s picture

merlinofchaos commented
Status: Active » Fixed

Make sure they're fully numeric. If they contain things like thousands separators, they'll be interpreted as strings by the math expression parser and that won't work. That's the most likely explanation.

SharonD214@aol.com’s picture

SharonD214@aol.com commented

Thanks, I did have a dollar sign. Works great now, thanks!

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.