Simple If/Then Statement 2

[jlhart76]

I'm trying to create an if/then statement, but am having trouble. The fields are:
A = Total # of consumers during month
B = Total # of consumers meeting criteria X

I need a statement that says if A=0, then return a value of "N/A". Otherwise, divide B from A.
I've tried several different ways, but I keep getting "A string is required here" error message. Please help.

 

[bdreed35]

Both sides of the if/then/else need to return the same data type, so you need to convert the result of the division to text:

if {table.total_consX} = 0 then
"N/A"
else
totext({table.total_cons}/{table.total_consX},2)

~Brian

 

[synapsevampire]

If you need to work with the result as a number, an alternative would be to use a formula for display purposes only:

if {table.total_consX} = 0 then
"N/A"
else
totext({table.total_cons}/{table.total_consX},2)

Then you can create a formula for use with calculations such as:

if {table.total_consX} = 0 then
0
else
{table.total_cons}/{table.total_consX}

-k