InputAvg Limitations?

[paulm]

Hi,

I am currently using a number of inputavg pivots one of which is not showing up correctly.  I have tried recreating it, analysing the figures below and cannot find any issues. Normal "avg" function works perfect.

Does anyone know a limitation of InputAvg that I could focus my search on?

Thanks
Paul

[Anonymous · Accepted solution]

Check that the inputfield has been populated correctly, as if the table it is in is amended after the inputfield is added to it, that inputfield can be changed to some form of autonumber.

Another thing to check, if you are manipulating the inputfield, is whether you should set a distribution mode in the second paramater of the inputavg() function. I usually set this as '*'.

Jonathan

[paulm]

Hi,

Yes the input field had a single duplicate in it which was casuing the issue.

Thanks

Paul