Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to calculate a field in a diagram:
(sum(Price1)+sum(price2)) / sum(cost)
It doesn't work right: Do u have any idea how to get multiplication and division first, then addition and subtraction?
THX
Do you mean this:
=Sum((Price1 + Price2)/Cost)
Although I would do this rather - it will handle nulls properly:
=Sum(RangeSum(Price1, Price2)/Cost)
What you provide the expression will work. And it works and starts from Left - Right. Ref image attacched
Do you mean this:
=Sum((Price1 + Price2)/Cost)
Although I would do this rather - it will handle nulls properly:
=Sum(RangeSum(Price1, Price2)/Cost)