1 Reply Latest reply: Dec 29, 2014 10:39 AM by Gysbert Wassenaar RSS

    i write this code for percentage expression showing error

      ='(' & if(IsNull(num(count(DISTINCT {$<Link_Flag={'Resolve'},  TicketStatus={'Resolved','Closed'},Process={'$(vProcess)'}>} TicketID)/

      count(DISTINCT {$<Process={'$(vProcess)'}>} TicketID),'###.##%')),

      0,

      num(count(DISTINCT {$<Link_Flag={'Resolve'},  TicketStatus={'Resolved','Closed'},Process={'$(vProcess)'}>} TicketID)/

      count(DISTINCT {$<Process={'$(vProcess)'}>} TicketID),'###.##%')) & ' )'

        • Re: i write this code for percentage expression showing error
          Gysbert Wassenaar

          To begin with replace the if statement with the alt function:

           

          ='(' & alt(num(count(DISTINCT {$<Link_Flag={'Resolve'},  TicketStatus={'Resolved','Closed'},Process={'$(vProcess)'}>} TicketID)/count(DISTINCT {$<Process={'$(vProcess)'}>} TicketID),'###.##%'),0) & ')'

           

          Then if that still gives an error, which I assume it will, post a document that demonstrates the problem. Without looking at the expression in the context of your document it is not possible to tell what is wrong.