If statement Expression

IF Statement

Using the IF Statement in the reportal expression builder is much like using the IF statement within excel.

if(cellv(col-1,row)>0,cellv(col-1,row)/cellv(col-1,6),0)

 

If the cell value of the column -1 and row is greater than 0, do the calculation else put in 0.

This is perfect for a percentage forumla on a table when there is yet to be any data avaialble.