Expression gives resluts which is twice the actual value

[#1]

Hi All,

In a text box I have  the below expression

='Total Charges: ' & num(round(Sum(TOTALCHARGES)),'$########,###')

In a table box I am using the same filed TOTALCHARGES along with other fileds.

In text box i am getting value  double than the value in Table box. Please see the below screen shot. Also in the list box the filed TOTALCHARGESshows the frequency as 2. that is the reson why it is getting doubled. How can we handle this?

[tresesco]

If you want to get the sum right in text box, try sum() with distinct like:

Sum(Distinct TOTALCHARGES)

[stephenedberkg]

num(Sum(Distinct TOTALCHARGES),'$#,###.00')

[SreeniJD]

Try this -

AGGR(Sum( DISTINCT TOTALCHARGES),fieldname)

[#5]

Thanks Tresesco,

If I am using DISTINCT in the expression then the Total sum of all the records will be wrong, since it will add only distict values in the field TOTAL_CHARGES, rit?

[tresesco]

You are right.