Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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?>
thanks,
Anat
Hi,
Can you attach Sample Data.
Thus Plan\Target PTDS and Actual - Completed are under field??
hi,
I defined those fields like this in the transform script:
left join (Table)
load order_id,
if(Indicator='Indication','Plan_Target_PTDs',
if(Indicator<>'Indication' and project_status='In progress','In_progress_PTD',
if(Indicator<>'Indication' and project_status='completed','Actual_completed')))
as order_status_PTD
Resident Table;
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?
Hi
please see the excel and the model. I need the difference between row 1 and row3 in the model.
PFA
Thank you Anil,
I am working with Anat and we need help with that also:
Limor
Perhaps this?
Don't duplicate for single issue - Re: % Prediction Accurancy