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.
| 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 KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
osirisa
Constraint Violating Yak Guru
289 Posts |
Posted - 2008-03-25 : 17:01:46
|
| Thank You tkizer :) |
|
|
|
|
|
|
Need Help with an "NaN" Error