Show zero when result of formula is zero on Account Schedule

kelseykong@hotmail.com
kelseykong@hotmail.com Member Posts: 86
edited 2012-10-17 in NAV/Navision Classic Client
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

Comments

  • MBerger
    MBerger Member Posts: 413
    Ever checked the "BlankZero" property of the control ?
  • kelseykong@hotmail.com
    kelseykong@hotmail.com Member Posts: 86
    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
    Sunset Member Posts: 201
    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 := '';
    Don't just take my word for it, test it yourself

Categories