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()).

Formatting formulas on the canvas

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	10	2542	February 27, 2023
Ability to format sliders & canvas formulas as currency, percents, etc Suggestion Box	3	1115	February 27, 2023
Format numbers and currencies on the canvas	8	4119	September 22, 2025
Display as percent in inline formula?	11	4093	January 11, 2021
Launched: More Currency format options & Format formulas News from Coda	14	612	September 25, 2025

Formatting formulas on the canvas

Related topics