Error in the report expression

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

Error in the report expression

Author

Topic

shm
Yak Posting Veteran

86 Posts

Posted - 2009-01-07 : 05:51:48

hi

in the report table footer,i have given an expression for that am getting the result as NaN
but i have to get zero
am doing some calculation in the exp,
i have given like this in the exp

=Iif (Sum(Fields!CodeReview.Value)+SUM(Fields!DesignReview.Value)+SUM(Fields!TestCaseReview.Value)+SUM(Fields!Requirement.Value)<>0,Sum(Fields!CodeReview.Value)+SUM(Fields!DesignReview.Value)+SUM(Fields!TestCaseReview.Value)+SUM(Fields!Requirement.Value)/Sum(Fields!CompletedComplex.Value)+Sum(Fields!CompletedMedium.Value)+Sum(Fields!CompletedSimple.Value),0)

that is ex: 2/73 it shld come 0 but it is coming NaN

if i have nt use that IIF stat also it is coming result as NaN

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-07 : 10:49:34

=Iif (Sum(Fields!CompletedComplex.Value)+Sum(Fields!CompletedMedium.Value)+Sum(Fields!CompletedSimple.Value)>0,Sum(Fields!CodeReview.Value)+SUM(Fields!DesignReview.Value)+SUM(Fields!TestCaseReview.Value)+SUM(Fields!Requirement.Value)/Sum(Fields!CompletedComplex.Value)+Sum(Fields!CompletedMedium.Value)+Sum(Fields!CompletedSimple.Value),0)

that is ex: 2/73 it shld come 0 but it is coming NaN

shm
Yak Posting Veteran

86 Posts

Posted - 2009-01-08 : 00:28:08

hi visakh

i tried that but again it is coming like that only the result as NaN

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-08 : 03:17:12

what does below give you?

Sum(Fields!CodeReview.Value)+SUM(Fields!DesignReview.Value)+SUM(Fields!TestCaseReview.Value)+SUM(Fields!Requirement.Value)

shm
Yak Posting Veteran

86 Posts

Posted - 2009-01-08 : 04:53:34

there are 4 cols am adding those and doing some calculation

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-08 : 08:26:49

quote:
Originally posted by shm

there are 4 cols am adding those and doing some calculation

ok...i was asking result that gives and also this

Sum(Fields!CompletedComplex.Value)+Sum(Fields!CompletedMedium.Value)+Sum(Fields!CompletedSimple.Value),0)

shm
Yak Posting Veteran

86 Posts

Posted - 2009-01-12 : 06:44:59

hi

this il return the value 2
Sum(Fields!CodeReview.Value)+SUM(Fields!DesignReview.Value)+SUM(Fields!TestCaseReview.Value)+SUM(Fields!Requirement.Value)

this il return the value 73
Sum(Fields!CompletedComplex.Value)+Sum(Fields!CompletedMedium.Value)+Sum(Fields!CompletedSimple.Value)

am doing the cal 2/73
it is coming NaN

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-17 : 03:04:39

try enclosing all fields within val()

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources