Hello Everyone, I am new to Netsuite. I apologize ...
# beginners
p
Hello Everyone, I am new to Netsuite. I apologize if my question is too basic. I am changing a saved search which pulls data from multiple project tasks. I want date A from project task A and date B from project task B. In the criteria section I added 'Project Task: Name' starts with 'Project Task A' 'Project Task: Name' starts with 'Project Task B' In the results section I mentioned the formula like this: CASE WHEN {projecttask.status} = 'Completed' THEN {projecttask.startdate} ELSE NULL END -- Should be from Project Task A CASE WHEN {projecttask.status} = 'Completed' THEN {projecttask.enddate} ELSE NULL END -- Should be from Project Task B However, the qualifier always points to the Project Task A since it is ahead in the order in criteria. Could anyone please suggest where am I missing?