How to do total of column in text object.

[#1]

I have a column called current and I want to display total of this in text object with $ amount.So,I want to have $614,293 .Sum(Current) will give different value.

0

  6,494.00

39,253.00

  56,000.00

481,216.00

12,000.00

19,330.00

Thank you.

[miguelbraga]

Hi Pavana,

Can you please attach your qvw or give a snapshot of your problem? If not, can you, please, elaborate better your question? I'm not sure I understood correctly.

Regards,

MB

[alexandros17]

Try with

Sum(TOTAL Current)

let m

[sunny_talwar]

Can you share a sample?

[#5]

Sum(Current) and sum(Total Current) will give 7371516.

I want to display $614293 in text box.

[settu_periasamy]

Are you using set any analysis in your straight table?

Use the same expression in text box too..

[sunny_talwar]

Can you share your qvw sample file is what I meant?

[miguelbraga]

Like Settu have said you must do something like this:

In your textbox please use this expression:

=sum(StraightTableLine1)+sum(StraightTableLine2)+sum(StraightTableLine3)+sum(StraightTableLine4)+sum(StraightTableLine5)+sum(StraightTableLine6)

Your sum(StraightTableLine1) must be the results of the expression in your Straight Table for your first line.

Hope it helped

Regards,

MB

[yura_ratu]

Hi,

Looks like you have duplicated values in this field. What you see in a chart - sum of distinct values, but in the textbox - sum of all values.

If you want to sum only distinct values in a textbox, try this - Sum(Distinct Current)

[#10]

Hi Pavana,

I have tried with your data and Sum(Current) is working fine.

Attached the qvw.

If its not working with you then provide a qvw with sample data which you are having.

Anjali Gupta