11 Replies Latest reply: Oct 20, 2017 5:20 AM by Ali Bouderbala RSS

    How to generate a calculated field with count ( ) or Sum in the load script ?

    Ali Bouderbala

      Hi experts !

       

      I want to generate a calculated column in the load script to use it in my set analysis

       

      Case :

      I want to load this expression as a column

       

      Expression:

      =Count({<[State] = {'UK'}>} [Customer])

       

      Example:

       

      =Count({<[State] = {'UK'}>} [Customer]) as UK_CUSTOMERS


      Please tell me how can i do that ?


      Regards

      Ali