12 Replies Latest reply on Oct 16, 2018 8:25 AM by Don Wise

    Calculation Help

    Barb Reiser

      I need to be able to calculate the number of reservations that do not have a gross revenue of $0, based on the resv date time (gnr count calc is in the measures). So in the example in the attached workbook, it shows 17 gnr's. It should actually be 16. When I try to filter the gross revenue, removing anything that is $0, it removes the gnr's but it also removes calls handled. How can I calculate this so it only removes the gnr's and not the calls handled?