Post reply

Divide by Zero frustration

  • October 8, 2013 at 9:46 am

    #1656804

    Nifty trick....thanks for that.

  • September 22, 2014 at 7:22 am

    #1747065

    I tried this approach. it ddn't work for me. please help me..

    Public Function Divider (ByVal Dividend As Double, ByVal Divisor As Double)

    If IsNothing(Divisor) Or Divisor = 0

    Return 0

    Else

    Return Dividend/Divisor

    End If

    End Function

    =Code.Divider(cstr(cint(Sum(Fields!DRGMatch.Value),CountDistinct(Fields!LocalID.Value+Fields!UIUserID.Value)*100)))+"%"

    got the below Error:

    Textbox16.Paragraphs[0].TextRuns[0]’ contains an error: [BC30198] ')' expected._

  • September 22, 2014 at 10:38 am

    #1747183

    ashok_k_ghattamaneni (9/22/2014)

    I tried this approach. it ddn't work for me. please help me..

    Public Function Divider (ByVal Dividend As Double, ByVal Divisor As Double)

    If IsNothing(Divisor) Or Divisor = 0

    Return 0

    Else

    Return Dividend/Divisor

    End If

    End Function

    =Code.Divider(cstr(cint(Sum(Fields!DRGMatch.Value),CountDistinct(Fields!LocalID.Value+Fields!UIUserID.Value)*100)))+"%"

    got the below Error:

    Textbox16.Paragraphs[0].TextRuns[0]’ contains an error: [BC30198] ')' expected._

    My guess is that you have a paren in the wrong place. Check the bolded text and play around with where the parens should be.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • November 3, 2015 at 11:39 am

    #1837453

    Matt and toolman - Thanks, I needed this!

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply