8 Replies Latest reply: Apr 3, 2018 5:21 AM by Stefan Wühl RSS

    count(distinct(if(Reason=1,Reason))) expression cannot count how many reason ?

    Yeo Poh sai

      Hi All

       

      I like to display the total number of Reason ?

      Now my reason field have 10 reason. may i know how to display it on the count column.

       

      I try below , but cannot work :-

       

      count(distinct(if(Reason=1,Reason)))

       

       

       

      Paul