I created a report in Crystal X which has a formula calculated number in the group footer and a Subreport in the same group footer. I am trying to subtract a value from my supreport from a value on the main report, but when I add the formula shared NumberVar GP; to the sub and main report, it makes the first value 0 and the other values are reading from the previous record.
For instance
The report looks about like this
ITEM# | GP%| GP%2 (From subreport) | DIFFERENCE (formula GP%2-GP%)
101 | 25%| 35% | 25
102 | 30%| 40% | 5
For some reason, the 1st value is 0, so 25-0 = 0 and then for the next record it pull the number from the 1st record so 30-35=5
The difference should be 10 for the 1st one and 10 for the 2nd one.
Any idea why this is happening?
IP Logged
