Use format in Tabular 2 Editor

[dandreev]

Hello,

I'm trying to format a result in a calculation item like that 123.4% or 23.4%. When I use format in like: ###.#% I get a value that is not I expect. I read the documentation, but couldn't manage to format the way I wanted. In short, I want to show percentage with just one value after the dot.

Thank you!

[dandreev]

I solved the problem like that 

format (VariancePcnt,"0.0") & "%"

I'm open to see if there is a better solution.

Thank you 

[qqqqqwwwweeerrr]

Hi @dandreev 

I am assuming that you might have created the measure (

VariancePcnt

). if yes the first click on your measure.

on data section then once you click over there. on top measure tool will pop up click on that there you can see percentage 

ignore the measure i have created. In this way you can get % value.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: www.youtube.com/@Howtosolveprobem

Regards

[dandreev]

Hi,

It's not a measure rather it is a calculation item within a calculation group in Tabular Editor 2.
There are other calculation items within that group that need to be formatted in its own way.

Thank you!