3 Replies Latest reply: May 22, 2017 11:30 AM by Stefan Wühl RSS

    Count 2 columns, without overriding information


      Good afternoon!

      How do I count information from 2 columns, without undoing an information.

      Below the percentage should give 57.1%, but in this expression, the status WOCOMP is canceled and is giving 50%.



      Count({<[Status] = {'WOCOMP','CLOSE','RETURNED','ISSUED'},[MotivodaPostergação]={'CUSTOMER','MATERIAL','RESOURCES'}>}[Status])/Count({<[Status] = {'WOCOMP','CLOSE','DONE','RETURNED','ISSUED','SAFETY','INPRG','RTO'}>}[Status])