In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
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

Hi,

 

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

 

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

 

1 REPLY 1
IraWatt
17 - Castor
17 - Castor

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 

 

Labels
Top Solution Authors