topic Re: Do not want to use Code = 'PC07' to calculate in App Development

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

Sxbbb — Fri, 15 Nov 2024 21:33:13 GMT

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

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

BrunPierre — Mon, 24 Jul 2023 09:42:55 GMT

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)

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

Sxbbb — Tue, 25 Jul 2023 06:37:28 GMT

thank you very much