There are a few calculation methods available in for a flowfield. This is a great feature in NAV to aggregate amounts from ledger entries. I would like Microsoft to add an option to the flowfield declaration. I would like to be able to omit zeros when using methods; Average, Exist, Count, Max and Min. In a normal SQL it is possible to use NULL to archive this result but not in NAV.
Posted inDynamics NAV & BC Tips & tricks