calculate average for values > 0

[TomBond77]

Hi experts

This formula works fine:

avg( ([Entry Date (CPUDT)] - [Posting date]))

This formula not:

avg( ([Entry Date (CPUDT)] - [Posting date])-={'0'})

Any ideas how to solve this issue?

Thank you, Tom

[MarcoWedel · Accepted solution]

maybe like 

Avg(If([Entry Date (CPUDT)]<>[Posting date],[Entry Date (CPUDT)] - [Posting date]))

or using some key field and set expression instead of the If() function:

Avg({$<Key={"=[Entry Date (CPUDT)]<>[Posting date]"}>} [Entry Date (CPUDT)] - [Posting date])