Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Try with
Sum(TOTAL Current)
let m
Can you share a sample?
Sum(Current) and sum(Total Current) will give 7371516.
I want to display $614293 in text box.
Are you using set any analysis in your straight table?
Use the same expression in text box too..
Can you share your qvw sample file is what I meant?
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
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)
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