Totals not adding up correctly for % fields

I’m getting incorrect totals for my % field. instead of getting the overall % profit, it’s adding the % values. the % value is calculated value for earnings based on the initial investment. Anyone familiar with how to fix?
image

Hi @ntjc

how would be great you can share the calculation as well as the profit numbers.
Only with the screenshot i would say it looks right.

BR

Hi Erik, this is an example scenario. The returns are adding up to 40% but it should be 20% on the dashboard
image

Hi @ntjc
In that case you need an avg aggregation and not sum.
BR

1 Like

I see, but I want the other fields to sum up, while that % field to average. is that possible?

isnt your table something like
grafik
Attention to the value area!

Hey Erik, I really appreciate you taking your time to reply to this thread. I was just able to get a grasp of the issue w/ the calculation and resolved it. Thanks!

HI @ntjc
perfect. Could you please solve the topic?
BR

1 Like