Joined: 05 Aug 2009
Online Status: Offline
Posts: 1
Topic: How to sum a sum? Posted: 05 Aug 2009 at 7:09am
Hello, I hope you can help me. I created a formula containing a field from a DB and a formula "Sum ({@CurPremSumEr}) + {PremiumAdjustment.Prem_Adj_Er}" and now I need to make total SUM of those fields in the reports. The formula @CurPremSumEr is defined like this "Sum ({RenewalTransactions.Prem_Period_Er}) + {PremiumAdjustment.Prem_Adj_Er}". How can I do this? I tried to create other SUM but it doesn't work as SUM (@CurPremSumEr). Thanks a lot!!!
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 05 Aug 2009 at 1:30pm
I usually create a shared variable, you can create the sum, that is already being displayed, add it to a variable, and then display the original value in a formula.... somethin like
shared numbervar bigSum;
local number littleSum := sum({table.field}, {group});
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum