# Showing the Percentage of Time Passed as a Progress Bar

Topic Labels: Formulas
Solved
Jump to Solution
1074 3
cancel
Showing results for
Search instead for
Did you mean:
5 - Automation Enthusiast

Hey Wonderful Community!

I am currently having an issue with a formula that I am trying to show as a progress bar. Here are the specifics:

I am calculating the percetage of time passed between a start date and an end date. The formula seems to be correct:

ROUND((DATETIME_DIFF(NOW(), {Start Date}, 'days') / DATETIME_DIFF({End Date}, {Start Date}, 'days')) * 100, 2)

However, when I go into the "Formatting" section of the Formula Field, it gives me a very large percentage which seems to be incorrect (in this particular case the preview shows 345600% but in the formula section, the preview shows 35.56%. I have attached the two images of the settings below:

Please can someone help me? xx
1 Solution

Accepted Solutions
18 - Pluto

Try removing the *100:

``ROUND((DATETIME_DIFF(NOW(), {Start Date}, 'days') / DATETIME_DIFF({End Date}, {Start Date}, 'days')), 2)``

If you're displaying it as a bar you can try removing the ROUND too as there isn't much of a difference visually I reckon

Link to base

3 Replies 3
9 - Sun

Hello @MegKrashCourse

You've done nothing wrong here. The formula is correct but airtable just used a different approach(nature) to handle the formula field.
Go to this official help page https://support.airtable.com/docs/number-based-fields-in-airtable#percent-fields
Read this and more.

The percentage field type hosts numerical values formatted as percentages. The values in a percent field are shown as fractions of 100 with the percent symbol. For example, .75 in a percent field is represented as 75%.

If you still can't understand then see other user has same issues https://community.airtable.com/t5/development-apis/percent-field-is-appending-0-0-to-the-value-i-try...

Let me know more.

👍

18 - Pluto

Try removing the *100:

``ROUND((DATETIME_DIFF(NOW(), {Start Date}, 'days') / DATETIME_DIFF({End Date}, {Start Date}, 'days')), 2)``

If you're displaying it as a bar you can try removing the ROUND too as there isn't much of a difference visually I reckon

Link to base

5 - Automation Enthusiast

Oh my gosh! You're amazing! Thank you so much!