I have this table:
the last row is the difference between the third and first rows.
what do I put in the expression in order to show difference?>
Thus Plan\Target PTDS and Actual - Completed are under field??
I defined those fields like this in the transform script:
left join (Table)
if(Indicator<>'Indication' and project_status='In progress','In_progress_PTD',
if(Indicator<>'Indication' and project_status='completed','Actual_completed')))
the order_status_PTD , is the calculated field for Plan/Target PTD etc... those are Dates, and we group orders by those Dates.
Would you mind, Can you attach application to test?
Thank you Anil,
I am working with Anat and we need help with that also:
Don't duplicate for single issue - Re: % Prediction Accurancy