Do not want to use Code = 'PC07' to calculate

[Sxbbb]

I tried the code : (Aggr(Sum(DISTINCT if ((INPUT ) >0 ,(INPUT ), [REWORK])),WorkOrderNo) -Aggr(Sum(ARY),WorkOrderNo))/Aggr(Sum(DISTINCT if ((INPUT ) >0 ,(INPUT ), [REWORK])),WorkOrderNo)

Result 

Do not want to use Code = 'PC07' to calculate

Do not want to use Code = 'PC07' to calculate

[BrunPierre · Accepted solution]

Try this.

Aggr(Sum({$<Code -= {'PC07'}>} DISTINCT If (INPUT > 0, INPUT, [REWORK])), WorkOrderNo)
-
Aggr(Sum({$<Code -= {'PC07'}>} ARY), WorkOrderNo)
/
Aggr(Sum({$<Code -= {'PC07'}>} DISTINCT If (INPUT > 0, INPUT, [REWORK])), WorkOrderNo)

[Sxbbb]

thank you very much