DIFF IN PERCENTAGE

Question

Hi,

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

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

IraWatt · Accepted Answer

Hey @BRRLL99,

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

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%20Expressions

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com