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.

Offsetting totals

ManuelRodrigues
8 - Asteroid
‎11-22-2023 07:58 AM

Hi have some issues flagging the offsetting values here as there are more than one instances when i use excel formula. I basically need a flag as shown in column B for the numbers that offset to zero. your help is greatly appreciated!

Preview file
1 KB
Labels:
Reply
0 Likes
2 REPLIES 2
binuacs
21 - Polaris
‎11-22-2023 08:53 AM

@ManuelRodrigues what is the logic to calculate the offsetting values? Eg: 5124.75 has three instances where where the two are yes and one is no

Reply
0 Likes
CoG
14 - Magnetar
‎11-22-2023 11:02 AM

This is similar to some other posts (here is one of them): https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/conditional-statement-or-offse...

Here is a sample workflow that I believe accomplishes what you are looking for:

Screenshot.png

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