We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

DIFF IN PERCENTAGE

BRRLL99
11 - Bolide
‎08-18-2022 04:43 AM

Hi,

 

NAMETOTAL OF 2020TOTAL OF 2022diff in %
A138092143382 
B7127065418 
C25425004 
D4022847752 

 

i would like have diff in percentage considering 2020 as base year

 

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
IraWatt
17 - Castor
17 - Castor
‎08-18-2022 04:46 AM

Hey @BRRLL99,

You can do & Diff in the formula tool with a formula like this:

IraWatt_0-1660823170684.png

The community has some quick and easy videos on formulas and the Formula Tool here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Writing%20...

 

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

 

Workflow.yxmd
Reply
0 Likes
Live Office Hours
Labels
Top Solution Authors
View All