Hi All
I have a problem with a rule in that I have 4 values against the weeks of a month one of which is zero, I want to use the ConsolidatedAvg function on these values in order to calculate the monthly average.
When I do this I am setting the flag value to 0 which I believe should mean that zero values will not be ignored however it seems that the calculation is still ignoring the zero's and is oly dividing the values by 3 and not 4.
Any help would be appreciated.
Have now logged this with IBM who have replicated the issue and logged it as a defect with the development team.