DataGrid - access another field from the same row in template

I'm using a DataGrid to display some data where at least one column is being calculated inside the code. Now I have another column that could use that calculated data for further processing. Is there a way to refer from one RadzenGridColumn template to another and get the value of the same row?

As a concrete example: one column gets raw data from the database and sums it up, showing that sum. The next column then holds amount and the last column would multiply amount and sum to a total number.

Hi @flipswitchingmonkey,

The column value isn't available. However you can use the underlying data item available as the template context. Something like:

<RadzenGridColumn TItem="DataItem" Title="Sum">
   <Template Context="data">
      @data.Sum
   </Template>
</RadzenGridColumn> 
<RadzenGridColumn TItem="DataItem" Title="Total">
   <Template Context="data">
     @(data.Sum * data.Multiplier)
   </Template>
</RadzenGridColumn> 

Ah, that's perfect! I wasn't aware that the data item "survives" between the columns.

Sir, How can I get Sum of this custom Column in the footer???