Formula help

[Kinetic_analytics]

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

[OllieClarke · Accepted solution]

@Kinetic_analytics 

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

here's the config of the summarize tool:

Hope that helps,

Ollie

[ChrisTX · Accepted solution]

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 · Accepted solution]

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]

Thank you. :)