Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Need Help with an "NaN" Error

Author  Topic 

osirisa
Constraint Violating Yak Guru

289 Posts

Posted - 2008-03-25 : 15:06:48
Text Box Expression - Calculating a Percentage.

=Round((Fields!Net_Receipts.Value-Fields!Deliveries.Value)/Fields!Deliveries.Value*100,2)


Text Box Format
="0.##'%';-0.0#'%'"

The problem is that I am also getting an infinite calculation representing "NaN". How can I change this for zero or not showing anything at all (leave it blank).

Any Help, Thank YOu

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-03-25 : 15:15:27
Put an IIF around the whole thing and don't use your formula if Deliveries.Value is 0.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

osirisa
Constraint Violating Yak Guru

289 Posts

Posted - 2008-03-25 : 17:01:46
Thank You tkizer :)
Go to Top of Page
   

- Advertisement -