Multiple the sum of a column

Stimulsoft Reports.WEB discussion
Post Reply
haleb
Posts: 16
Joined: Thu Sep 19, 2019 2:32 pm

Multiple the sum of a column

Post 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'"
HighAley
Posts: 8431
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Multiple the sum of a column

Post by HighAley »

Hello,

Please, try to use the next expression:

Code: Select all

 {Sum(DataBand6,reports_InventoryTransactions.TotalCost)*0.15M}
Thank you.
haleb
Posts: 16
Joined: Thu Sep 19, 2019 2:32 pm

Re: Multiple the sum of a column

Post by haleb »

Thank you! That worked perfectly!
Andrew
Posts: 4104
Joined: Fri Jun 09, 2006 3:58 am

Re: Multiple the sum of a column

Post by Andrew »

You are welcome!

Take care!
Faviandrade
Posts: 1
Joined: Fri Sep 09, 2022 12:29 pm

Re: Multiple the sum of a column

Post 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ó
Lech Kulikowski
Posts: 6245
Joined: Tue Mar 20, 2018 5:34 am

Re: Multiple the sum of a column

Post by Lech Kulikowski »

Hello,

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

Thank you.
Post Reply