Forum Discussion
Calculate completed operation and date difference
Hi, I'm trying to calculate Completed? column based on serial #s, operations 10-30 = completed operation based on serial #. Then calculate the date difference between completed serials (10 and 3...
Adding && doesn't seem to work. Appreciate any insight, thank you.
Completed? =
VAR __serial = [Serial #]
VAR __table = FILTER('table', [Serial #] = __serial && [Operation] = "10" && [Operation] = "30")
RETURN
IF(COUNTROWS(__table)+0 > 0,"Y","N")