This content has been marked as final. Show 4 replies
I would like to create the equivalent of an If(And()) statement, as seen in Excel, in the QV script.
I would like an output of '1' if column A = column B = column C, and an output of '0' if this is not true. I imagine the syntax would be something like the following, but haven't got it quite right:
if([A] = [B],if ([B] = [C],1,0)) as [D]