hi all,
whats wrong with my expression?
i am trying to transfer the logic of the load script in report expression as below:
If(Match(Workflow_Name,'EMEA Start Review Cycle') and Match(TaskName,'Other Review') or Match(TaskName,'EMEA Scientific Department 1 Review')or Match(TaskName,'EMEA Scientific Department 2 Review'),1) as rev_start_counter,
to
=Aggr(sum({<workflow_name = {'Workflow_Name,'EMEA Start Review Cycle'}, task_name = {'Other Review'}/ task_name={'EMEA Scientific Department 1 Review'}/task_name{'EMEA Scientific Department 2 Review'} >} 1) ,document_number)
=Aggr(Sum({(<workflow_name='EMEA Start Review Cycle'> , <task_name='Other Review'>) + <task_name='EMEA Scientific Department 1 Review'> + <task_name='EMEA Scientific Department 2 Review'>}1),document_number)
no error came but the expected value also did not come.
kindly help.
thanks,