Hi all,

Having a bit of trouble with an If formula when creating a formula field with currency return type.

This is what I've got:

If(Now()>=${Agreement History.Rent Review Due}, '${Agreement History.Holdover Price}', 'Abs(${Agreement History.Rent Achieved                               1}+${Agreement History.Rent Achieved                                    2}+${Agreement History.Rent Achieved                                    3})')

Which gets the error message: Incorrect data type of argument

I've tried it this way too:

If((${Agreement History.Rent Review Due}<=Now()), '${Agreement History.Holdover Price}', (Abs(${Agreement History.Rent Achieved                               1}+${Agreement History.Rent Achieved                                    2}+${Agreement History.Rent Achieved                                    3})))

and get the same error... since I need it to end in a currency value, I'm finding it difficult to figure out how to structure the If formula or what to add.