Add % symbol to a double

[TarekIMEX]

Hi everyone, I would like to add a pourcentage symbol following a double value.

I can't use 'Tostring' fonction because I'm using the value within a formula.

Does anyone have a solution ?

Thank you all.

[rzdodson]

@TarekIMEX my suggestion here is to force the value in to a string at first opportunity to keep that percentage sign you need, and then Formula manipulate the syntax to get it to function as a numeric value where you need it.

Attached is a small use case to demonstrate:

[Sample Data]*ToNumber(Trim(Replace([Value],"%","")))

[danilang]

Hi @TarekIMEX 

I would suggest that you keep the field as a double until just before you output it to it's final destination.  That makes the formulas that use the value much easier to maintain since you don't need to strip the "%"(and possibly put it back) in every operation.   

The only time that you see the % values are in the intermediate results when you're running the workflow in Designer.  So unless your output requirements are to screen shot the results, just remember that certain columns are percentages or add % to the column name. 

Dan