BO Reports: have a formula produce a null

crystal-reports sap business-objects
Robert Brown picture Robert Brown · Apr 2, 2012 · Viewed 8.8k times · Source

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).

If it possible?

(Business Objects 12 - Web editor)

Answer

Lee Tickett picture Lee Tickett · Apr 2, 2012

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

Related questions

How to Hyperlink to a Business Objects Report in Infoview

Is there a way to craft a hyperlink that connects to a Crystal Report or Webi within Infoview? Ideally, unauthenticated users would be challenged with Infoview security and then redirected to the report. Thanks!

Read More
Getting the values of the maximum record

I am facing some difficulties while developing a report. The problem is that I am getting a number of values in the Details section and I want only to display the record which it is having the maximum event number …

Read More
SAP Crystal Reports runtime for .Net 4.0 (64-bit)

I need a runtime for SAP Crystal Reports for .Net 4.0 (64-bit). I have been searching from the web but not getting any success. Can I get the URL from where can i download this

Read More