display text last

[soniasweety]

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

[YoussefBelloum]

Hi,

=avg(Days) &' Days'

[soniasweety]

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 · Accepted solution]

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

[soniasweety]

thanks used below

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

[YoussefBelloum]

you're welcome

[soniasweety]

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]

Floor: rounds the value down

Ceil: rounds the value up

you can try this:

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

[soniasweety]

tried this working   thanks

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

[YoussefBelloum]

you're welcome.

Good luck