Search code examples
crystal-reportsbusiness-objects

BO Reports: have a formula produce a null

I need to have a formula produce a null in some cases, numeric in others. Then I'll use number formatting to present accordingly. Something like this:

=If(Count([Product Id]) = 1) Then null Else [Amount]

Unfortunately null is not a recognised keyword. I've tried nil and nothing also (clutching at straws).

Is it possible?

(Business Objects 12 - Web editor)

Solution

  • Try just =If(Count([Product Id]) <> 1) Then [Amount]