Add Calculated Field doubt

[Andrew Ofthesong]

Hi... I have this:

Set fsNewFieldSet = oView.AddFieldSet("ResponseRateA")
fsNewFieldSet.AddCalculatedField "ResponseRateB", "ResponseRate",
"fldResponseRate", "(fldC/fldB)"

And works fine... However, if i try to make an if:

Set fsNewFieldSet = oView.AddFieldSet("ResponseRateA")
fsNewFieldSet.AddCalculatedField "ResponseRateB", "ResponseRate",
"fldResponseRate", "=if(fldB=0,0,(fldC/fldB))"

i get an error...

i searched MSDN i it says "Expression Required String. The expression used
to calculate the items in the new field. The expression must be compatible
with the Jet expression service."...

What Am'i doing wrong??

 

[Dip]

Hi,

Just a thought,



Set fsNewFieldSet = oView.AddFieldSet("ResponseRateA")

fsNewFieldSet.AddCalculatedField "ResponseRateB", "ResponseRate",

"fldResponseRate", "=if(fldB=0,0,(fldC/fldB))"



From this code, can you remove "=" and use "IIF" instead of "IF" the try
coding like this?



"fldResponseRate", "IIF(fldB=0,0,(fldC/fldB))"

This should work.

Dip

 

[Andrew Ofthesong]

Yeah!, thanks