Page 1 of 1

Multiple the sum of a column

Posted: Tue Apr 07, 2020 5:24 pm
by haleb
Is there a way to multiple the sum of a column from a databand?

This is being placed within a Footer band. {Sum(DataBand6,reports_InventoryTransactions.TotalCost)*0.15}

However this is causing two errors: "Operator * cannot be applied to operands of type 'decimal' and 'double'" and "Operator * cannot be applied to operands of type 'string' and 'double'"

Re: Multiple the sum of a column

Posted: Tue Apr 07, 2020 8:37 pm
by HighAley
Hello,

Please, try to use the next expression:

Code: Select all

 {Sum(DataBand6,reports_InventoryTransactions.TotalCost)*0.15M}
Thank you.

Re: Multiple the sum of a column

Posted: Wed Apr 08, 2020 4:48 pm
by haleb
Thank you! That worked perfectly!

Re: Multiple the sum of a column

Posted: Thu Apr 09, 2020 4:16 am
by Andrew
You are welcome!

Take care!

Re: Multiple the sum of a column

Posted: Fri Sep 09, 2022 12:41 pm
by Faviandrade
Bom dia, eu possuo um relatório que tem 02 databan ligados por um parametro , eu preciso colocar como se fosse um groupfooter com os totais somandos informações dos 02 das bands, é possível somar bands diferentes em um footer só

Re: Multiple the sum of a column

Posted: Tue Sep 13, 2022 7:30 am
by Lech Kulikowski
Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.