Expand my Community achievements bar.

Radically easy to access on brand approved content for distribution and omnichannel performant delivery. AEM Assets Content Hub and Dynamic Media with OpenAPI capabilities is now GA.
SOLVED

Calculation fields need to hide $0 and 0% fields when null

Avatar

Level 2

Adobe Live Cycle Designer 8.0

I have my Before DIR% calculated by dividing (TotalDebts/TotalIncome*100) and have it show up as a percentage (ie 26% OR  31% instead of .26 or .31). I need it to show up blank if there isnt anything going on. Same for "After DIR" and "% Unsec to Inc". I also have another from with the same exact problem but it calculates a $0. How would make these 0's show up blank when no calculation is currenlty happening?  I am trying to get them to show up as blank so if needed I could print out the form and hand write it and NOT have the 0% show up.

Capture.JPG

1 Accepted Solution

Avatar

Correct answer by
Level 4

It is the Display Pattern option. Try putting "null{}|zero{}|num{zz9'%'}" as your Display Pattern. It should work.

View solution in original post

6 Replies

Avatar

Level 4

If you set the Pattern display on the calculated cell to allow zeros and/or null then if both of the numericFields are 0, then the calculated cell is blank; not 0. Just select the calculated cell that has the 0, then in the Object tab select the Field tab, and there should be a "Patterns" button you can click. Select "Display" from the drop down box after hitting "Patterns", and then check the fields "Allow Empty" and/or "Allow Zero". Should not display the 0 once you have those set.

Avatar

Level 2

In my LiveCycle, I don't have those options.... is there another way to get to that menu?

Capture.JPG

Avatar

Correct answer by
Level 4

It is the Display Pattern option. Try putting "null{}|zero{}|num{zz9'%'}" as your Display Pattern. It should work.

Avatar

Level 2

That is exactly what I needed. Thank you very much. That is also much simpler than I was trying to make it.... =)

Avatar

Level 10

Are you using an old version of Designer? It's odd that you don't have all the options on the Field tab.

Avatar

Level 2

Yes I was using LiveCycle 8.0 instead of the updated version.