is there a way to force the format formulas on the canvas? i’m trying to display a quick ratio by dividing two currency columns. it’s displaying as a decimal and i’m wanting it represented as a percentage.

Hi @Stefaan_Dumez , good point. And even more compact: Format("{1:00.0}%",[Rendement Actual]/[Rendement Estimate]*100) i.e. in the Format() function you can put variables and text (therefore, no need of Concatenate() and ToText()).

I have the same question. Anybody some idea?

After some searching, I found a rather elaborate workaround: concatenate(format("{1:00.0}",totext([Rendement Actual]/[Rendement Estimate]*100)),"%") gives 78.9% as result.

Dear @Federico_Stefanato , Thank you pointing out the benefits that “format()” includes. Especially for people without a “coding background”, like me, it’s rather important to be aware of this :diamond_shape_with_a_dot_inside:

Hi @Federico_Stefanato , do you know is there is a more complete formula description than @ https://coda.io/formulas ? The latter clearly doesn’t cover all the richness of the formula language.

Hi @Stefaan_Dumez , unfortunately, not (yet). I heard that a more comprehensive reference will be on radar (hopefully with a playground), but so far is all that we have.

The problem with both our solutions: it returns a string => can’t calculate with it… I just forget about the % in the formula. I type it on the canvas after the formula. It’s always there and formula returns a number that can be used in calculations. Problem solved as far as I’m concerned. Than…

I see your point. I didn’t know that was a formula referenced elsewhere. In this case you can put the value in an intermediate Named Formula so that you can use it both on other computations and in the formatting. But I guess this is exactly what you have done. :wink:

@Stefaan_Dumez @Federico_Stefanato If you needed to refer to the number from this string, you could also convert it to a value in the formula you are using to include this parameter in: e.g. Rendement % Formula On Canvas = Format(“{1:00.0}%”,[Rendement Actual]/[Rendement Estimate]*100) Now I w…

Hi @Kolbi_Christianson , thanks for your feed-back. Some questions from a Newbie: I can’t find the value() function. Do you mean ToNumber()? Why the @ before the variable?

Formatting formulas on the canvas

Superhuman Ask the Community

Alex_Parks May 11, 2020, 3:51pm 10

that DID solve my use case however- thanks all!

Launched: More Currency format options & Format formulas

Topic		Replies	Views
How to format formula values on the Canvas Showcase & Tips	10	2604	February 27, 2023
Ability to format sliders & canvas formulas as currency, percents, etc Product Feedback	3	1146	February 27, 2023
Format numbers and currencies on the canvas Ask the Community	8	4211	September 22, 2025
Display as percent in inline formula? Ask the Community	11	4177	January 11, 2021
Launched: More Currency format options & Format formulas News from Superhuman	14	829	September 25, 2025

Formatting formulas on the canvas

Related topics