Percent

[CiaoPaola]

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 solution]

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 solution]

hi @atcodedog05 

thank you 

I'll try your suggestions. 

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

[atcodedog05]

Hi @CiaoPaola 

I am guessing it's something like 3 digits before decimal and 0 after but since this percentage I am a bit unclear.

All the best hope you find out though 🙂👍

[soroosj]

Is the above Percent formula a Salesforce formula?  I don’t think Alteryx has a percent formula.

if hypothetically yes, is there a similar user group for Salesforce that you could post the question?