Error Calculation after subtracting with another set of analysis of Aggr function

[THWTEMJIRAS]

I'm can't solve this issue for a week now. If anyone could help, I would greatly appreciate it. Thank you very much.

I have expected that the highlight yellow column "[Required Delivery Date - Today - Num Aggr]" as screenshot below, it should show some result of subtraction between the next two columns on the right column (examples)

"1)[ Num Required Delivery Date-Today]" - "2) [Aggr (ATA-ATD)]", but only some line that have a result (-1111-(+2) = 1109)

Here is my current formula to combine those two columns toget,

=

num([Required Delivery Date])-num(today())

-

aggr(sum({<[PO Number]=,[Material_Code]=,[PO Item Status]=>}(num(ATA)-num(ATD))),Material_Code)

/

aggr(count({<[PO Number]=,[Material_Code]=,[PO Item Status]=>}(num(ATA)-num(ATD))),Material_Code)

[marcus_sommer · Accepted solution]

You may try it by adjusting the aggr() approach like: aggr(NODISTINCT ...) or with sum(aggr(...))

Further you could simplify the expression by removing the various num() which are having no effect and also trying to combine the sum() and count() within a single aggr() like:

sum(aggr(sum() / count(), Dim))

[THWTEMJIRAS]

Thank you very much for your suggestion. It's work 😀