Finance | Project Operations, Human Resources, ...

Display 0 in field (real) only if the amount is 0, otherwise field should be blank

(1) Share

Report

Posted on by devgirlX

102

Hello,

I have a field that should not show 0 by default, that is why I have property Show zero set to No

But the issue is that sometimes I need to display here zero if the calculation of the amount is actually 0.

How can I achieve that in those cases it should be populated with 0 and in other , by default it should be blank?

Thanks in advance

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Sohaib Cheema 49,664 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

If you try to maintain it by trying to manage it using x++ to modify it, using the control name/types, that may bring more complexity as people can add more field (or the same filed) multiple times, using the personalization.

You may convert your results to a display method and your display method can show the data as per your wish.

Was this reply helpful? Yes No
Jonas "Jones&q... 5,016 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I'd say display method of type string.

Do you need to be able to filter or sort by the field?

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

If the field that you are mentioning is a real/int then by default, the value will be 0. It is not possible to make it empty.

Only way is to have a display method of return type string where while returning value, the integer or real should be converted to string. If at all this is already a base or existing field, you can make the field invisible and create a new display field and the functionality can be achieved.

Was this reply helpful? Yes No
Suggested answer

Sankar Ramalingam 262 on at

Like (0)

Report
Copy link

Link copied!

You can make "Fixed amount" Form control property "Show zero" toggle Yes/No in the Form datasource active() method based on your requirement. If its Yes, then it will show 0 else blank.

Was this reply helpful? Yes No
Anton Venter 20,670 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Can you explain functionally why it should behave like this? If you use a display method of type str, you will probably have other issues like formatting etc.

Was this reply helpful? Yes No