Fill cell based on value - grouped by identifier

[Hamder83]

Hi 

I have a dataset, with a total price of a group.
I want to divide this price with the count of the group and the fill the price cell.

So I want to devide [Total avt.pris] with [Count] and fill the Total avt. pris with the result,  below grouped by kolli number.

And i assume i have to use multi field formula, but i cant quite figure how to do it?

[afv2688 · Accepted solution]

Hello @Hamder83,

Is this what you are looking for?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[Hamder83]

Hi 

This is excactly what I was looking for.

it seems so logic when I look at it now.... thus i spend hours yesterday trying to figure it! 


Thank you very much .-) 

[afv2688]

You are welcome!

Glad I could help you with it 🙂

Regards

[sneha_bhiwagade1]

Hi,

Yes you can implement this with a Multi row formula 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

Sneha