3 Replies Latest reply: Aug 17, 2017 3:22 AM by sahra sahraoui RSS

    Calculate the number of rows in a column with condition

    sahra sahraoui

      Hello,

       

      I have the following expression :

       

       

      if([Type de commande] = 'URGENT' or  [Type de commande] = 'GROS' or [Type de commande] = 'PVI' ,Aggr( count([N° de commande]),[N° de client]),1)

      And I want to calculate the order number for each customer number

      And thank you in advance