

SSCInsane
Group: General Forum Members
Last Login: Thursday, January 16, 2014 12:03 PM
Points: 21,376,
Visits: 9,594


SSRS is annoying with that.
Use this code to do the division (rename as you wish, this is not Ms Access after all! ).
PUBLIC FUNCTION NDZ(Numerator, Denominator, DZResult) IF Denominator = 0 THEN RETURN DZResult ELSE RETURN Numerator / Denominator END IF END FUNCTION




Grasshopper
Group: General Forum Members
Last Login: Saturday, July 21, 2012 3:10 PM
Points: 22,
Visits: 22


My problem was to display zero if the value of the denominator is zero, else the division of the two fields. So what I used is mentioned below,
iff(Field2=0,0,Field1/Field2)
I worked.. Hope it does the same for you all...




Grasshopper
Group: General Forum Members
Last Login: Thursday, August 23, 2012 7:11 AM
Points: 11,
Visits: 407


@penelson re: =((Sum(Fields!field3.Value) / Sum(Fields!field1.Value) * 10 + Sum(Fields!field4.Value) / Sum(Fields!field1.Value) * 10 + Sum(Fields!field5.Value) / Sum(Fields!field1.Value) * 10 + Sum(Fields!field6.Value) / Sum(Fields!field1.Value) * 10)  (Sum(Fields!field7.Value) / Sum(Fields!field2.Value) * 10 + Sum(Fields!field8.Value) / Sum(Fields!field2.Value) * 10 + Sum(Fields!field9.Value) / Sum(Fields!field2.Value) * 10 + Sum(Fields!field10.Value) / Sum(Fields!field2.Value) * 10)) / (Sum(Fields!field7.Value) / Sum(Fields!field2.Value) * 10 + Sum(Fields!field8.Value) / Sum(Fields!field2.Value) * 10 + Sum(Fields!field9.Value) / Sum(Fields!field2.Value) * 10 + Sum(Fields!field10.Value) / Sum(Fields!field2.Value) * 10)
shouldn't the operand before Sum(Fileds!field7.Value) be a '+' sign?




SSCertifiable
Group: General Forum Members
Last Login: Thursday, April 10, 2014 8:19 AM
Points: 7,002,
Visits: 6,181


All,
I received my answer to this question a long time ago. If you need assistance with a similar problem, please start a new thread as you are more likely to get responses to your question if you post in a thread that doesn't have pages of answers or a thread which says "Problem Solved" in the third or fourth post.
Not a lot of people are going to read beyond my comment of "problem solved."
This is just a friendly public service announcement.
Brandie Tarvin, MCITP Database Administrator
Webpage: http://www.BrandieTarvin.net LiveJournal Blog: http://brandietarvin.livejournal.com/ On LinkedIn!, Google+, and Twitter.
Freelance Writer: Shadowrun Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.




SSC Journeyman
Group: General Forum Members
Last Login: Tuesday, March 18, 2014 7:25 AM
Points: 93,
Visits: 422


=IIf( IsNothing(Sum(Fields!divisor.Value)) Or Sum(Fields!divisor.Value) = 0.0, "", Sum(Fields!value.Value) / IIf(IsNothing(Sum(Fields!divisor.Value)) Or Sum(Fields!divisor.Value) = 0.0, 1, Sum(Fields!divisor.Value)) )
I just wanted to add a fact: If you have a division, that does not allow you to use the divisor "1" instead of "Nothing" you can still use the suggested solutions in this tread:
What you have to do is use your conditions twice: first your "old" way: IIf(Sum(Fields!divisor.Value) = 0.0, "", ... Then in the dvision: ...Value) / IIf(IsNothing(Sum(Fields!divisor.Value)) Or Sum(Fields!divisor.Value) = 0.0, 1, Sum(...
As you can see, you still have a divsion by 1 implemented but it can never be reached as you ruled it out before. That makes the renderer and you happy ;)




Forum Newbie
Group: General Forum Members
Last Login: Tuesday, October 08, 2013 9:45 AM
Points: 3,
Visits: 30


Nifty trick....thanks for that.



