April 27, 2024

MoDCore

Welcome to the core

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.

 

Copyright © All rights reserved. | Newsphere by AF themes.