3 Replies Latest reply on Oct 29, 2018 5:16 AM by Mahfooj Khan

    Number of Occurrences

    David Gabra

      HI

      Please can you correct me and let know how to fix

       

      I want to count the number of expenses per trip per employee, where the schema is not cancelled.

       

      My effort is dismal.

      I added in the expected results in tableau - my formuale do not work at all.

       

      {

      FIXED [Trip Number],[Personnel Number]: COUNT([Travel Expense Type]="taxi" if not [Schema name]= "cancel")

      }

       

      {

      FIXED [Trip Number],[Personnel Number]: COUNT([Travel Expense Type]="Car" if not [Schema name]= "cancel")

      }

       

      {

      FIXED [Trip Number],[Personnel Number]: COUNT([Travel Expense Type]="Train" if not [Schema name]= "cancel")

      }

       

       

      Please help and correct.

       

       

      Thank you

      Attached if needed.

      David.