Make an addition of 3 values

[Woody]

Hello
I'm trying to do the following:

Value 1 : {SumD(DataBand2,QuoteLine.TotalAmount)}
Value 2 : {SumD(DataBand3,QuoteLine.TotalAmount)*0.15}
Value3 : {SumD(DataBand1,QuoteLine.TotalAmount)}

All these formulas works fine.
Then in one other cell i wish to add these 3 values.

We have tried a lot of differents ways without success.
Can someone help me please?

Thank you very much
Olivier

[Alex K.]

Hello,

Can you please send us a sample report with test data which reproduce the issue for analysis.

Thank you.

[Woody]

Hello
Thanks for the help
i have joined my template and i hope you 'll understand my question.
( I'm not a developper so i have 0 knowledge of programing)
A developper friend of mine tried using keywords like Parse but didn't succed.
Thanks again
Olivier

[Woody]

Hello
Looks the file i sent was not in the good format.

i didnt mentioned that the data are in string format.
Thanks

[Alex K.]

Hello,

Can you please send us a test data for your report.
Also please try to use the Totals function - Totals.SumD(...)

Thank you.

[Woody]

Hi
i'm sorry i do not know what you mean by a test data
i have asked 2 developpers to write the formula but the couldn't find a way to add the values.

How can i write in one line the sum of theses 3 values

Value 1 : {SumD(DataBand2,QuoteLine.TotalAmount)}
Value 2 : {SumD(DataBand3,QuoteLine.TotalAmount)*0.15}
Value3 : {SumD(DataBand1,QuoteLine.TotalAmount)}

My english is not terible i'm sorry and i'm not a developper.

[HighAley]

Hello.

Please, try to use next expressions:

Code: Select all

Value 1 : {Totals.SumD(DataBand2,QuoteLine.TotalAmount)}
Value 2 : {Totals.SumD(DataBand3,QuoteLine.TotalAmount)*0.15}
Value3 : {Totals.SumD(DataBand1,QuoteLine.TotalAmount)}

Thank you.

[Woody]

Hello
i'm not sure you understood what i meant
there is 4 pages in each page i have a formula
Value 1 as : {SumD(DataBand2,QuoteLine.TotalAmount)} in page 1
Value 2 as : {Totals.SumD(DataBand3,QuoteLine.TotalAmount)*0.15} in page 2
Value 3 as {Totals.SumD(DataBand1,QuoteLine.TotalAmount)} in page 3
I want in a page 4 have a formula to make the sum of all the values 1+2+3

Thank you very much.
Does someone nows how to have a skype or a live support? even if we have to pay.

[Alex K.]

Hello,

As a way, you can try to add the additional variable for save the Value1, Value2 and Value3, which sets in the AfterPrint event of DataBands (DataBand1, DataBand2, DataBand3). And show the result on last page.

Thank you.

[Woody]

Hi
i guess i'll give up using this tool , my company bought this software and even 4 month after trying i'm not able to make an addition.
i'm a little sad, i'm sorry i do not have a good level, i was expecting that an addition should be easy.
thanks for the help