This is a migrated thread and some comments may be shown as answers.

How to suppress Zero dollars?

2 Answers 93 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Jon
Top achievements
Rank 1
Jon asked on 24 Aug 2010, 07:39 PM
Hi..
How can I suppress  "$0.00"  so it shows up as blank?

Most of my fields are based on calculations..... like...
 
=Fields.inv_sale -  Fields.sale_paid


thanks again

2 Answers, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 25 Aug 2010, 08:51 AM
Hi Jon,

You can use a simple expression utilizing the built-in IIF function:

= IIf(Fields.ProductID - Fields.ProductID = 0, "",  Fields.ProductID - Fields.ProductID)

Best wishes,
Steve
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Jon
Top achievements
Rank 1
answered on 25 Aug 2010, 03:05 PM
thanks again
Tags
General Discussions
Asked by
Jon
Top achievements
Rank 1
Answers by
Steve
Telerik team
Jon
Top achievements
Rank 1
Share this question
or