Round Off Problem

jhanvincent14

Good day,

I want to calculate the Percentage from "PMF" and "Cost of Land" and showing it in messagebox (see attached picture) but it shows Zero(0) in "COGS Percentage" column. I want to show the output like (15%). anyone can help me? badly need it

Albertvh

Hi,
You would have to display a variable in that field and change your message.

MESSAGE('COGS Percentage: ' + FORMAT("COGS Percentage") + ' %');

So you would do something like this
define a variable as text call it COGSPct
Make this the field on you page instead of "COGS Percentage" field
In the OnAfterGetRecord section add you calculation

vDecimal := ROUND("Cost of Land" / "Lawn Lot Amount");
COGSPct := FORMAT(vDecimal) + ' %';