Hello!

I am not well versed with Razor, c#, etc., so please forgive my ignorance, but I am having a hard time determining a way to compare a cell value to another value that I do not want in the model. Example cell script below:

@{
//Display negative values in red and bold
ResultCell cell=Model;
ReportElement element = cell.Element;
ReportModel reportModel = element.Model;
Report report = reportModel.Report;
//For performances reason, consider to process your result table in a dedicated Task with an execution step 'Models generated, before rendering'
if (cell.DoubleValue > [COLUMN IN MY QUERY, BUT NOT ONE I WANT DISPLAYED IN THE FINAL REPORT OUTPUT]
{
cell.FinalCssStyle = "font-weight:bold;color:red;";
cell.FinalCssClass = "danger lead text-right"; //These are Bootstrap classes
}


}


Is there a way to reference a value in my table that is not in my model (set it as a var or such)? Or is a way to hide a column from the final output while sill having it in the model, where the cell reference in bold is hidden from the final results?

(cell.DoubleValue > cell.ContextTable[cell.ContextRow,cell.ContextCol+1].DoubleValue)

Really appreciate any help!

Thanks so much, that worked as you described!

For anyone else who was having a hard time finding these settings (as I was), DataTable is down under Views-->Model Container-->Data Table along the right hand side. :)