在crystal reports公式编辑器中减去wo字段

Question

我在crystal reports中添加了两个相同类型的业务对象List<DenominationDataEntity>。1. ReceivedDenomination 2. PaidDenomination。

我必须显示两个列表的值，然后我必须减去两个列表字段的值。

例如。ReceivedDenomination和PaidDenomination都有字段Thousand，现在我必须减去ReceivedDenomination.Thousand和PaidDenomination.Thousand的值。我用下面的代码创建了Formula Field。

Global numberVar TotalThousand :=0;

(if IsNull({ReceivedDenomination.Thousand}) then
     TotalThousand
else
     TotalThousand := ToNumber({ReceivedDenomination.Thousand})
);

(if IsNull({PaidDenomination.Thousand}) then
    TotalThousand
else
     TotalThousand := TotalThousand + ToNumber({PaidDenomination.Thousand});
);
TotalThousand

我遇到的问题是TotalThousand字段返回错误的答案。即如果

ReceivedDenomination.Thousand是85，PaidDenomination.Thousand是2，那么我得到的是2而不是83。

Answer 1

你试过这样做吗？

Global numberVar TotalThousand :=0;
Global numberVar RcvdThou := 0;
Global numberVar PdThou := 0;

(if IsNull({ReceivedDenomination.Thousand}) then
     TotalThousand
else
     RcvdThou := ToNumber({ReceivedDenomination.Thousand})
);

(if IsNull({PaidDenomination.Thousand}) then
    TotalThousand
else
     PdThou := ToNumber({PaidDenomination.Thousand});
);
TotalThousand := RcvdThou + PdThou;
TotalThousand;

如果这仍然给您带来问题，请尝试将公式分成多个公式，并查看每个字段为您提供了什么。所以你会有一个TotalThousand，RcvdThou，PdThou和一个总的formala。TotalThousand将实例化global，而RcvdThou和PdThou将显示2个数字，而Total将提供数学运算。