ToDecimal function conversion in Matrix
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.
Comments
It looks like you have incorrect data inside the Garanzia.Importo capitale 1
Mea culpa.
There was some mess with the bands . Now it works.
Thanks again.