Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Formula help

Kinetic_analytics
11 - Bolide

Hello:

Great people. Good morning. I am stuck in formulating a formula: How can I create a formula: I want to sum up/

=IF Business Final ="S Other.", Sum (Sum of YTD CAD) where Posted Currency = [whatever currency in that row]

Company Name

IF Business_Final

Posted Currency

Sum of YTD CAD

A

S Other.

GBP

500

B

Cong

USD

800

C

S Other

GBP

400

D

S Other.

GBP

900

 

Appreciate your help.

Thanks

4 REPLIES 4
OllieClarke
15 - Aurora
15 - Aurora

@Kinetic_analytics 

 

You don't want a formula to do this, but rather a summarize tool and a filter

OllieClarke_0-1667314882481.png

here's the config of the summarize tool:

Screenshot 2022-11-01 at 15.04.24.png

 

 

Hope that helps,

 

Ollie

 

ChrisTX
15 - Aurora

Use a Filter tool with the formula [Business_Final] = "S Other."

 

Then use a Summarize tool.  Group by [Business_Final] and [Posted Currency], SUM [Sum of YTD CAD]

 

Chris

leonhekkert
8 - Asteroid

Hi @Kinetic_analytics,

 

could you try to use a summarize tool, groupby on IF Business_Final ánd posted currency and sum on Sum of YTD CAD.

After that filter on IF Business_Final = 'S Other'.

 

 

Kinetic_analytics
11 - Bolide

Thank you. :)

Labels