Show zero when result of formula is zero on Account Schedule

kelseykong@hotmail.com

Hi Dear Experts,

I would like to confirm with you whether NAV could show zero on account schedule if the comparasion result is zero.

For example, I would like to show current year balance, previous year balance and Difference on BS report(created in Account Schedule), is it possible to show zero if the difference is zero (i.e. 2000-2000=0)? It shows blank on the report I generated.

Thank you.

Li

MBerger

Ever checked the "BlankZero" property of the control ?

kelseykong@hotmail.com

Thank you for your prompt reply.

I checked blankzero for Column Values and found the option is set up as No.

The result is the same if I change it to yes.

Any suggestion?

Thank you.

Li

Sunset

The value being shown on the account schedule is a text. So you need to the code and remove/comment out the lines saying:

IF Value = 0 THEN
Text := '';