Formula help

Question

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 Answer

@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 Answer

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 Answer

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'.