Need help

[anithaMallam]

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.

[amitchandak]

@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]

Hi Amit,

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

Regards

Anitha

[v-shex-msft]

Hi @anithaMallam,

I'm still not so clear about your requirement, can you please share some dummy data with expected results to help us clarify your data structure and test coding formula?

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng