Forum Discussion

anithaMallam's avatar
anithaMallam
Helper III
5 years ago

Need help

Hi All,

           Could some one please help how to implement the below requirement.

To showcase the differences from the Customer where there is no CustomerGroup and AccountType assigned.

 

Could someone please help me how to write a condition for this one.

 

Regards

Anitha.

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    anithaMallam ,Can you share sample data and sample output in a table format? Or a sample pix after removing sensitive data.

     

    You can have a new column like

    if(isblank([CustomerGroup]) && isblank([AccountType]) , "No Assignment", "Assignment")

    • anithaMallam's avatar
      anithaMallam
      Helper III
      5 years ago

      Hi Amit,

                      i want to show customers where there is no customer group  but account type assigned to the customers.

       

      Regards

      Anitha