Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
MauriceLudo
Creator II
Creator II

check field

Hi,

I try to test A_B_C

if A = Num '0000' and B = 'FR', 1, 0



thank you in advance
Best regards
Maurice

8 Replies
m_woolf
Master II
Master II

if(A = 0 and B = 'FR', 1, 0) as WhatEver

PabloTrevisan
Partner - Creator II
Partner - Creator II

Could you explain more?

m_woolf
Master II
Master II

Not without seeing your data and having a better understanding of what you are after.

All I did is write your statement using correct QV syntax.

PabloTrevisan
Partner - Creator II
Partner - Creator II

Yes, I asked him if he can explain better than he wishes.

m_woolf
Master II
Master II

Sorry Pablo. I confused you with Maurice.

MauriceLudo
Creator II
Creator II
Author

A = A is a numerical 4 digit

B equal FR

balabhaskarqlik

May be like this:

If(Len(A)=4 and B = 'FR', 1, 0)

MarcoWedel

-(IsNum(A) and Len(A)=4 and B='FR) as SomeFieldName