nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Alytrex Bug in understanding percentage data type

Ganesh123

Hello All,

Requesting all please look into this issue, One of the column data has percentage (%) 100.000021% value but while input this into Alytrex it changes to value. (1.00000021)

Because of this it very difficult us to figure out the resolution and annoying too.

could you please check what is the bug here?

why need to change this to percentage again with duplicate effort.

Please look into this if we can try to fix this issue from begining by simple adding the percentage type in data type.

please let me know if you need any additional information

Datasets

Input

Transformation

In Database

Data Investigation

In-Database

Accepted answers

All comments

Felipe_Ribeir0

Hi @Ganesh123

If i understood well your issue, there is no bug. When you look at a percentage value at excel for example (like the bellow image), when you see 100.000021%, this is just the label of the value, and this is meant just for visual purposes. The real value behind it is 1.00000021 (look at B2 = A2). When you import this to Alteryx, Alteryx will see the real value behind it, that is the useful value for making calculations.

Why would you need to have the % label inside of Alteryx?

apathetichell

Alteryx does not have a native percentage format. You can use a decimal based number (fixed decimal/float/double) or a text format and include the "%" sign. As @Felipe_Ribeir0 points out - this is not a bug.

Ganesh123

No. I think you took the wrong value in column B. what I am saying it is 1.0000. there is a decimal point.

why percentage sign don't show in Alytrex after downloading from input folder

Ganesh123

why do we need to additional formatting when it is already there in input file. this is unnecessary create more work.

Ganesh123

When you import this to Alteryx, Alteryx will see the real value behind it,

I don't agree with you I tried all this it shows value only.

Deano478

if you really want the % you'll have to change the data type of that column to a string

Ganesh123

Why do we need to add % if it is already there in my input file? that is my question

Deano478

@Ganesh123 as @Felipe_Ribeir0 mentioned Alteryx only looks at the real value and does not have a native percentage format hence the reason why its happening

Deano478

if you set the column to a string data type it should show up with the symbol

Ganesh123

I have did this by changing to percentage however it is not showing the excepted result.

Ganesh123

yes. but not the exact number

Ganesh123

According to me it is a bug as we working on those solution which is not a problem in first please.

Can we ask Alytrex team to fix this bug. If my column shows percentage it should as it is in Alytrex application

apathetichell

This thread has gone on way too long for something like this - here's the deal - excel has a percentage category (so does Salesforce) - that does not exist in most real data (ie every SQL source I can think of, programming languages) - Alteryx tries to be smart and recognizes this is a number and converts it to a double. It then does not have the "%" and is shown as a decimal. To convert this to a percent you can multiple by 100 - add a "%" and convert to string via tostring([field]*100)+"%". I would not refer to this as a bug. You can. You can tell your Alteryx rep. They can file a piece of information which will do nothing. But the key thing - at this point you should be able to get your workflow from point a to point b - and if not - maybe try posting on that so that people who want to help you - for free - because we like Alteryx- - can continue trying to help you.

Also - not to be pedantic here but like 15 messages in you can spell Alteryx correctly? I'm fine with one off mispellings but like it's in the URL.

also - Requesting all please look into this issue, One of the column data has percentage (%) 100.000021% value but while input this into Alytrex it changes to value. (1.00000021) -

https://www.khanacademy.org/math/mappers/operations-and-algebraic-thinking-220-223/x261c2cc7:percent-decimal-fraction-conversions/v/converting-percents-to-decimals-ex-1

Ganesh123

Thanks for your response.

I tried adding the percentage still it shows value in output.

apathetichell

Excel percentages vs excel strings with % in Alteryx.

percentages in excel.yxzp

sireeshagandam

good

jerryking

Hello,

It seems like you're facing a data formatting issue where a percentage value is not being handled correctly in Alytrex, resulting in an unexpected change in the displayed value.

To address this issue, you may consider the following steps:

Check Data Type Settings: Ensure that the column containing percentage values is correctly defined as a percentage data type in Alytrex.
Decimal Precision: Verify the decimal precision settings for percentage values. It's possible that the precision setting might be affecting the display.
Data Input Format: Double-check the format in which you are inputting the percentage values. Ensure that it aligns with Alytrex's expectations for percentage data.
Software Update: Make sure you are using the latest version of Alytrex. Sometimes, these kinds of issues are addressed in software updates.
Contact Support: If the problem persists, reach out to Alytrex's customer support. They can provide specific guidance or let you know if there's a known issue and when a fix might be available.

If you provide additional details about the data type, input format, and any specific error messages, I can offer more tailored advice.

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15908

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703