Need Help with Multirow Formula

[khawzkk]

Record ID	Name	Value	Prob	Prob2
1	0	A1	0.1	0.1
1	1
1	2
2	0	A2	0.2	0.04
2	1	A2	0.2
2	2

The output is Prob 2 which is the product of every Prob grouping by recordID

The data is group by RecordID mainly so I need to find the product of Value of each Record ID.

May I know how can I achieve this output?

Sorry if the question is not clear enough.

[KarolinaRoza]

Hi @khawzkk 

sorry but it is not clear for me.

What do you need to find for each Record ID?

Karolina

[DylanDowrick]

I'm not exactly sure what you were looking for so I just went ahead and put something together. Let me know if any of it helps.

[echuong1]

You can use a summarization to get the total, and then a formula and join to adjust the values accordingly.

[apathetichell]

multi-row-formula - new column (I called it product in the example)

group by record-id.

Your basic formula is something like:

if [Row-1:Record ID]!=null() then [Value]*[Row-1:product] else [Value] endif

Note - this is set up for "values for rows that don't exist = null()" - not = 0