How to avoid calculation if the required values are missing. - See details

Hi All,


I wanted to calculate the average of stocks for last 3 months. Everytime new month data is added it should automatically calculate the average for last 3 months.

In case if there are only 2 months for ex in feb we will have only feb and Jan, in such cases the calculation should not happen and it should give a null or blank value instead of 0.

Please help.

See attached dxp file.

Thank you


Binary Data testing_2.dxp152.13 KB

(3) Answers