Creating a Count to Zero Field

(0) Share

Report

Posted on by Community Member

I am trying to create a field that would show the number of days until X event. Specifically, I'm trying to measure how many days I have left to pay an invoice before the date to get any invoice discounts for early payment has passed. So, if I have three days until the discount due date, the field should show "3". If today is the discount due date, the field should be "0". If the discount due date has already passed, I'd like the field to say "Exp".

I've gotten the field to calculate the countdown by doing a DiffInDays calculation. I am having trouble getting the field to show the values as described above. I thought about creating a separate field and writing workflows to set the values, but didn't know if there was an easier way.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (2)

Report

RE: Creating a Count to Zero Field

Hello,

You can't have "Exp" for whole number field. You will have to either change your requirements or don't use calculated whole number field.

Was this reply helpful? Yes No
David Jennaway 14,065 on at

Like (1)

Report

RE: Creating a Count to Zero Field

One option would be to keep the calculated whole number field (which you can use for filtering or sorting), and have a calculated text field that displays either the number of days (if >= 0), or 'Exp', and display the text field

Was this reply helpful? Yes No
Verified answer

gdas 50,091 Moderator on at

Like (2)

Report

RE: Creating a Count to Zero Field

I think the way you thought is the easiest way to create new field .

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Creating a Count to Zero Field

Thanks for the feedback, guys! I ended up doing it the way that I'd originally planned. Works great.

Was this reply helpful? Yes No
a33ik 84,331 Most Valuable Professional on at

Like (0)

Report

RE: Creating a Count to Zero Field

Can you please share how you forced whole number calculated field to show "Exp"?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Creating a Count to Zero Field

I didn't. I just counted to zero and any day after the expiration date was a zero.

Was this reply helpful? Yes No