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

(Nick Parsons) #1

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

#2

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

(Nick Parsons) #3

@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 KULAÇOĞLU) #4

@Nick_Parsons1

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

(Nick Parsons) #5

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

(Levent KULAÇOĞLU) #6

@Nick_Parsons1

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

(Nick Parsons) #7

@Levent_KULACOGLU You have done it again !!

Superb thank you.