Using MITS Expression Language (MEL) in TEXT.BEFORE and TEXT.AFTER attributes.

In the TEXT.BEFORE and TEXT.AFTER attributes of the CELL and STOPLIGHT dashboard objects, MITS Expression Language (MEL) statements can be used to dynamically populate these fields.

There are three type of expressions you can use.  

evalCellNumeric()
This statement will evaluate the included MQL statement and return the value in the lower right most cell.

#{evalCellNumeric('FLASH COFFEEBEAR {RootPath} WITH CPL = "PL1"  CP SALES.Y SALES.Y-1')}

lowestLevelRowCount()
This statement returns the number of rows the included MQL statement

#{evalCellNumeric('FLASH COFFEEBEAR {RootPath} WITH CPL = "PL1" CP SALES.Y SALES.Y-1')}

Math functions
This statement just returns a value based on the results of the math function

Each of these will return a numeric value you can use as part of the TEXT.BEFORE TEXT.AFTER attributes.