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?
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
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
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