Calculate Geomean between two fields?

[Crispy131]

Hello, I want to calculate the geometric mean between two fields [value 1] and [value 2] at each month/ year level

The data looks like this:

2022  Jan  1.32   1.67

2022  Jan  1.09   1.08

2023  Aug  1.11   1.23

2023  Aug  1.25   1.33

In Excel it would just be something like Geomean(C2:D2) however in Alteryx it seems you have to take the log then avg then exp of the values but how would you achieve this when you have two fields you want to compare  (i.e. [value 1] and [value 2] above) and not just the values in a single column?

[Qiu]

@Crispy131 
Maybe I am missing something, but is it like this?

[flying008]

Hi, @Crispy131 

You need resolve the function 'GEOMEAN' of Excel by Alteryx,  ( I apologize, I mistakenly assumed you would be calculating the Geomean result value after grouping the data by year/month.)

Year	Mon	P1	P2	GEOMEAN
2022	Jan	1.32	1.67	1.269215
2022	Jan	1.09	1.08	1.269215
2023	Aug	1.11	1.23	1.227432
2023	Aug	1.25	1.33	1.227432