Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2008
    Posts
    2

    Unanswered:

    I am trying to get the Net Receipt Per Guest from a restaurant environment. It is the total Net Revenue YTD divided by Guest Counts YTD. I continue to receive - Division By Zero. Please assist.

    My formula: {@tot_net_rev YTD} / {@gc YTD}

    Thank you.

    Connie Schlegel

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Code:
    If {@gc YTD} = 0 Then
        {@tot_net_rev YTD}
    Else
        {@tot_net_rev YTD} / {@gc YTD}
    End If
    George
    Home | Blog

  3. #3
    Join Date
    Oct 2008
    Posts
    2
    George. This formula returned the total net revenue amount even though @gc (guest counts) calculation works on its own.

    Let me be a bit more clear.

    Net Revenue = $3873414 / Guest Counts 209060 which = 18.53. This is the answer I'm looking for, 18.53. It seems to be reading @gc YTD to be = to 0 which it is not. Thank you.

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Can you prove it's not zero in all cases?
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •