Hi all,

I need to calculate the value of a Formula Field (X) based on the value of 3 currency fields:

- If Field A is filled, X takes A's value

- If Field B is filled and A is not filled, X takes B's value

- If Field C is filled and neither A nor B is filled, X takes C's value

I found it difficult to represent whether a given field was empty or not, because there are no isEmpty( ) or isBlank( ) functions in the formula field builder.

I solved thisas follows...taking advantage of the fact that the length of an empty currency value is 1, while the length of a filled currency value (even $0.00) is 3:

If(Len('${Leads.Field A}')>2,${Leads.Field A},If(Len('${Leads.Field B}')>2,${Leads.Field B},${Leads.Field C}))

And this works. MOST of the time.

However, there are times when, for some reason, the Length of a filled currency field shows as 1.

I'm not sure why this happens, but it does. And when this happens, my value for X is wrong.

My question is - is it possible to approach this differently by:

1) Somehow fixing the inconsistent behavior of Len('${Leads.Field A}') etc?

2) Using a different function to determine whether A, B, and C are empty?

Thanks for any help!

Dave