Click here to Skip to main content
15,912,400 members
Home / Discussions / C#
   

C#

 
Generalregular expression to check a float value Pin
chithra.r15-Jan-08 19:38
chithra.r15-Jan-08 19:38 
GeneralRe: regular expression to check a float value Pin
N a v a n e e t h15-Jan-08 19:48
N a v a n e e t h15-Jan-08 19:48 
GeneralRe: regular expression to check a float value Pin
chithra.r15-Jan-08 23:09
chithra.r15-Jan-08 23:09 
GeneralRe: regular expression to check a float value Pin
N a v a n e e t h16-Jan-08 2:27
N a v a n e e t h16-Jan-08 2:27 
AnswerRe: regular expression to check a float value Pin
Nicholas.R15-Jan-08 22:34
Nicholas.R15-Jan-08 22:34 
GeneralRe: regular expression to check a float value Pin
N a v a n e e t h15-Jan-08 22:38
N a v a n e e t h15-Jan-08 22:38 
GeneralRe: regular expression to check a float value Pin
S. Senthil Kumar16-Jan-08 1:03
S. Senthil Kumar16-Jan-08 1:03 
GeneralRe: regular expression to check a float value Pin
Le centriste16-Jan-08 2:37
Le centriste16-Jan-08 2:37 
GeneralCopying files from folder to another Pin
ysunil_7415-Jan-08 18:50
ysunil_7415-Jan-08 18:50 
GeneralRe: Copying files from folder to another Pin
Abhijit Jana15-Jan-08 19:52
professionalAbhijit Jana15-Jan-08 19:52 
GeneralRe: Copying files from folder to another Pin
ysunil_7415-Jan-08 19:54
ysunil_7415-Jan-08 19:54 
GeneralRe: Copying files from folder to another Pin
JF201515-Jan-08 20:04
JF201515-Jan-08 20:04 
GeneralRe: Copying files from folder to another Pin
Abhijit Jana15-Jan-08 20:20
professionalAbhijit Jana15-Jan-08 20:20 
GeneralRe: Copying files from folder to another Pin
ysunil_7415-Jan-08 20:24
ysunil_7415-Jan-08 20:24 
GeneralRe: Copying files from folder to another Pin
J4amieC15-Jan-08 22:22
J4amieC15-Jan-08 22:22 
GeneralRe: Copying files from folder to another Pin
Vasudevan Deepak Kumar15-Jan-08 22:14
Vasudevan Deepak Kumar15-Jan-08 22:14 
GeneralUpdating propertygrid control Pin
netJP12L15-Jan-08 16:35
netJP12L15-Jan-08 16:35 
QuestionNeed some help using Membership and user authentication Pin
Shimmy Weitzhandler15-Jan-08 15:22
Shimmy Weitzhandler15-Jan-08 15:22 
QuestionGetting the maximum file size for a particular location Pin
Skippums15-Jan-08 12:31
Skippums15-Jan-08 12:31 
GeneralRe: Getting the maximum file size for a particular location Pin
Luc Pattyn15-Jan-08 13:20
sitebuilderLuc Pattyn15-Jan-08 13:20 
GeneralRe: Getting the maximum file size for a particular location Pin
Skippums15-Jan-08 13:40
Skippums15-Jan-08 13:40 
GeneralConverting Mapped Drive string to Server Name (UNC path) Pin
Leo Smith15-Jan-08 12:06
Leo Smith15-Jan-08 12:06 
GeneralRe: Converting Mapped Drive string to Server Name (UNC path) Pin
PIEBALDconsult15-Jan-08 14:16
mvePIEBALDconsult15-Jan-08 14:16 
Generalnull value needed in datacolumn expression Pin
yann bertaud15-Jan-08 11:14
yann bertaud15-Jan-08 11:14 
GeneralRe: null value needed in datacolumn expression Pin
yann bertaud15-Jan-08 12:51
yann bertaud15-Jan-08 12:51 
I found the solution

expression should be:
IIF(IsNull(Count1, -1) = -1 and IsNull(Count2, -1) = -1 and IsNull(Count3, -1) = -1, null, IsNull([count1],0) + IsNull([count2],0) + IsNull([count3],0))"

the first part of the IIF statement checks that all 3 count columns are null and returns -1 if they are. If all three conditions are true then the expression evaluates to null. Otherwise it totals up the value.

Yann

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.