Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
All-Star
35986 Points
6550 Posts
Oct 05, 2011 01:54 PM|LINK
I really don't understand what result you want. But to help you a little bit further:
When a field can contain either a numeric value, NULL of "na", You can use the following IIF function to change NULL and "na" in 0, so you can calculate with it:
IIF(IsNumeric([ps_projectmgmt]), [ps_projectmgmt], 0)
hans_v
All-Star
35986 Points
6550 Posts
Re: statement has a syntax error
Oct 05, 2011 01:54 PM|LINK
I really don't understand what result you want. But to help you a little bit further:
When a field can contain either a numeric value, NULL of "na", You can use the following IIF function to change NULL and "na" in 0, so you can calculate with it:
IIF(IsNumeric([ps_projectmgmt]), [ps_projectmgmt], 0)