Hi,

I need to do a formula in a report (Crystal Reports 11) which will be like the following. At the moment I have

forumla = SUM ({LineItems}, {AdditionalItems} + {@SharedItems})

But if for example, the user does not put in an additional item, the total field is blank.

Can anyone provide any advice on converting this incorporate an "IIF" and potentially an "ISNULL" statement? I'm using Basic Syntax, but can happily switch to Crystal if needed.

you can also leave your formula as it is and use the pick list option that is in the formula editor and change it from 'Exceptions For Nulls' to 'Default Values for Nulls'.

Edited by DBlank - 11 Oct 2012 at 3:28am