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.

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.