Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

display text last

Hi all

I want to display text along with measure

   [  kPI ] object

I tried below but I need last

='Days'& avg(Days)      result  Days10

but I need result   like     10 Days

1 Solution

Accepted Solutions
YoussefBelloum
Champion
Champion

=Floor(avg(Days)) &' Days'

View solution in original post

9 Replies
YoussefBelloum
Champion
Champion

Hi,

=avg(Days) &' Days'

soniasweety
Master
Master
Author

thanks.

but after adding that  the kpi value  displaying like    10.08169 days   I need exact 10days

checked in number format it is set to 1000

YoussefBelloum
Champion
Champion

=Floor(avg(Days)) &' Days'

soniasweety
Master
Master
Author

thanks used below

YoussefBelloum
Champion
Champion

you're welcome

soniasweety
Master
Master
Author

one quick question youssef belloum

if I use floor its giving without decimals.

if want one decimal means how can I use?

like 10.2 days ?

YoussefBelloum
Champion
Champion

Floor: rounds the value down

Ceil: rounds the value up

you can try this:

=Num(avg(Days),'# ##0,0') &' Days'

soniasweety
Master
Master
Author

tried this working   thanks

num(avg(Days),'###.#') & chr(10)&'Days'

YoussefBelloum
Champion
Champion

you're welcome.

Good luck