Add variables from database in a row and get average from all rows
Posted: Thu Apr 11, 2019 12:25 pm
Hi everybody !! I'm new to Stimulsoft and have some questions that I'm trying to solve.
I have some variables from a database that I have to add together in a row. Once they come from the DB as stings I had to convert to be able to add them together, so I used the following line:
{decimal.Parse(InfoMateriaBoletinBr.NotaNumEv1)+decimal.Parse(InfoMateriaBoletinBr.NotaNumEv2)+decimal.Parse(InfoMateriaBoletinBr.NotaNumEv3)+decimal.Parse(InfoMateriaBoletinBr.NotaNumEv4)}
I have a row at the end of each line in my report to get the totals that I need.
Now I need to get the average from all rows were I have results from my expression. What would be the best way to tackle this question ?
I have some variables from a database that I have to add together in a row. Once they come from the DB as stings I had to convert to be able to add them together, so I used the following line:
{decimal.Parse(InfoMateriaBoletinBr.NotaNumEv1)+decimal.Parse(InfoMateriaBoletinBr.NotaNumEv2)+decimal.Parse(InfoMateriaBoletinBr.NotaNumEv3)+decimal.Parse(InfoMateriaBoletinBr.NotaNumEv4)}
I have a row at the end of each line in my report to get the totals that I need.
Now I need to get the average from all rows were I have results from my expression. What would be the best way to tackle this question ?