community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More

Calculate Percentage

Im still quite new on Alteryx and having some issues with calculating a percentage 

 

Attached is my test work flow, basically im trying to get an available order to show 100%. The logic behind my formula is the available Qty/Total qty however when i run its populating a 0.

 

Any help would be massively appreciated!

 

Thanks

ozzy

 

 

Alteryx Certified Partner

Could you link the "Current Generic Data.xlsx" file or provide a sample? It's no included when you share a .yxmd. To include that supporting file, you'd need to use Options > Export Workflow and make sure that box is checked. 

Hi Charlie

 

ive now attached the excel data 

 

Thanks

Alteryx Certified Partner

Thanks for sharing that input. When I use that file, the formula seems to be calculating everything correctly. When I filter the records to only those that the formula should apply to, I see the 100 for all records.

 

20190321-ReservedPct.png

 

 

 

 

 

 

 

 

 

Maybe I'm looking at the wrong thing?

Labels