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?