Hi, Is there a way to stop this and have no d...

[Nick_Parsons]

Hi, Is there a way to stop this and have no decimal places?

[Lynn]

Hi @Nick_Parsons1 Have you tried setting the numeric digits or if it is derived from a formula maybe include ROUND()

[Nick_Parsons]

@Lynn Hi Lynn, Im not sure how, where would I add Round() to this formula?

If I can?

=IFS( ISNOTBLANK([Date Raised]),CONCATENATE(HOUR(NOW()-[Date Raised])/24," - (days)"), TRUE,CONCATENATE(""))

[Levent_KULACOGL]

@Nick_Parsons1

=IFS( ISNOTBLANK([Date Raised]),CONCATENATE(ROUND(HOUR(NOW()-[Date Raised])/24,0)," - (days)"), TRUE,CONCATENATE(""))

[Nick_Parsons]

@Levent_KULACOGLU Hi Levent, I get an error, saying round invalid inputs?

[Levent_KULACOGL]

@Nick_Parsons1

=IFS( ISNOTBLANK([Date Raised]),CONCATENATE(ROUND(HOUR(NOW()-[Date Raised])/24)," - (days)"), TRUE,CONCATENATE(""))

[Nick_Parsons]

@Levent_KULACOGLU You have done it again !!

Superb thank you.