Qual Formula Utilizar

Qual formula usar para continuar a equação :

Ainda preciso colocar, [Registro]="Devolução", ISBLANK([Registro])

Porem meu resultado esta ficando em branco;

 

padilha_0-1652299948817.png

 

 

0 3 96
3 REPLIES 3

Marc_Dillon_0-1652307931415.png

That doesn't make much sense.

You need to add those 2 other terms into the SELECT? Why don't you continue putting them in your AND()?

What do you mean the result is blank? What result?

Expression Result:

Com a formula inicial:

padilha_0-1652351308524.png

padilha_3-1652351751704.png

 

Expression Result, aplicando as duas formulas restantes na função AND():

padilha_1-1652351560176.pngpadilha_2-1652351645706.png

 

Obviously there are no records that meet all conditions, you need to verify what the data is versus what you are expecting it to be, and/or test each condition independently.

Your last 2 conditions are mutually exclusive. [Registro] can't possibly be both blank AND have the value of "Devolução". I don't know what you're trying to do, my only guess is to maybe use OR()?

Top Labels in this Space