calculate DIF between tow rows

[anatle1234]

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

[mdmukramali]

Hi,

Can you attach Sample Data.

[Anil_Babu_Samineni]

Thus Plan\Target PTDS and Actual - Completed are under field??

[anatle1234]

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.

[Anil_Babu_Samineni]

Would you mind, Can you attach application to test?

[anatle1234]

Hi

please see the excel and the model. I need the difference between row 1 and row3 in the model.

[Anil_Babu_Samineni]

PFA

[Anonymous]

Thank you Anil,

I am working with Anat and we need help with that also:

• Actual vs Planned displays gaps with the following color indication:
  • Red for negative gap.
  • Green for positive or zero gap.

Limor

[Anil_Babu_Samineni]

Perhaps this?

Don't duplicate for single issue - Re: % Prediction Accurancy