Formatting formulas on the canvas

13

@Stefaan_Dumez @Alex_Parks
I have a lot of corrections to make to my statement!! I was totally wrong!

So,

  1. Make your formula:

= Format(“{1:00.0}%”,[Rendement Actual]/[Rendement Estimate]*100)
this returns: 68.2%, for example

  1. Name that formula as “Rendement%”
  2. Refer to that number in another part of the canvas by:

=format(“{1:00.0}%”,Format(“{1:00.0}%”,tonumber([Rendement%])*[whatever you want]))
where if [whatever you want] = 25%
you get 17.1%

I should have tested my response before sending it, apologies for the misinformation.