ToDecimal function conversion in Matrix

Riddick61 · March 2020

Hi,

I have a matrix like this

where I added a column Totale (to calculate total by row) in which I set expression :

ToDecimal([Garanzia.Importo capitale 1]) + ToDecimal([Garanzia.Importo capitale 2])

but it returns error: System.Exception: Error in expression: Garanzia.Importo capitale 1

I tried then with a custom function in the code:

long MakeSum(object o1, object o2)

{

return Convert.ToInt32(o1)+ Convert.ToInt32(o2);

}

in the cell I call this function:

MakeSum([Garanzia.Importo capitale 1], [Garanzia.Importo tasse annuo])

but keep getting the same error: System.Exception: Error in expression: Garanzia.Importo capitale 1

The total by column, instead, works fine-

I there anyone who can help me ?

Thanks.

Anatoly · March 2020

It looks like you have incorrect data inside the Garanzia.Importo capitale 1

Riddick61 · March 2020

Mea culpa.

There was some mess with the bands . Now it works.

Thanks again.

Comments