CUSTOM COLUMN

[160475]

HI 

can anyone fix this formula for me ?

if [CUSTOMER_TYPE_DESC]="Individual"
and [CIFSegment]="NL" AND "MASS"
then MASS

thank you

[v-eqin-msft]

Hi @160475 ,

If the condition returns true ,then put  a text value "MASS" ,right?

if so, please try:

if [CUSTOMER_TYPE_DESC]="Individual" and [CIFSegment]="NL" or [CIFSegment]="MASS" then "MASS" else null

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Thejeswar · Accepted solution]

Hi @160475 ,

You can try this

if [CUSTOMER_TYPE_DESC]="Individual"
and ([CIFSegment]="NL" OR [CIFSegment]="MASS")
then MASS

else null

Regards,

[amitchandak]

@160475 ,  I think it should be like

if [CUSTOMER_TYPE_DESC]="Individual"
and ( [CIFSegment]="NL" or  [CIFSegment]= "MASS")
then MASS