PSFT Nvision - Formula in Excel 2010 appears to be '0'.
Hi,
We have been running PT 8.53.09 and 9.2 version and have got issue with custom nVision report.
in the Layout we tried to have sum of columns by putting =D13+E13 in column F13 but when we run the report and select the output from Report Manager it appears to be 0 although the D3 has amount of 1000, so ideally the behaviour should be D13 (1000) + 0 (E13) = F13 (1000). but it apperas to be 0. i tried =SUM(D13+E13) also but the output shows as 0.
One more observation that when we click on "Show Formula" under formula tab the F13 column doesn't show formula that i have put in under the layout.