Percent

Question

Hi

I'm preparing a data file to be loaded onto Salesforce.

the field I'm dealing with is a Percent field.

in the specs, I can read Percent(3,0)

the source values are "40%", 50%", "90", "100"

does anyone know what the (3,0) stands for ?

and how should I represent the data in my flow: with a "%" sign?

thank you for your help

paola

atcodedog05 · Accepted Answer

Hi @CiaoPaola

Haven't worked much with salesforce. As far as Alteryx goes we do not have a percentage datatype. Hence you might have to store data in the below fashion percent/100

40% -> 0.4

50% -> 0.5

It seems like salesforce is saving the same way. You can give this a try.

https://trailhead.salesforce.com/en/content/learn/modules/advanced_formulas/numbers_formulas

If that doesn't work you try 40 or 40% but note 40% would be treated as a string in Alteryx.

Hope this helps 🙂

CiaoPaola · Accepted Answer

hi @atcodedog05

thank you

I'll try your suggestions.

Still did not find what (3,0) means?😣