Solved: Re: Calculation-Problem in diagram - Qlik Community

Anonymous · ‎2017-10-12

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

jonathandienst · ‎2017-10-12

Do you mean this:

=Sum((Price1 + Price2)/Cost)

Although I would do this rather - it will handle nulls properly:

=Sum(RangeSum(Price1, Price2)/Cost)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

Anil_Babu_Samineni · ‎2017-10-12

What you provide the expression will work. And it works and starts from Left - Right. Ref image attacched

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

jonathandienst · ‎2017-10-12

Do you mean this:

=Sum((Price1 + Price2)/Cost)

Although I would do this rather - it will handle nulls properly:

=Sum(RangeSum(Price1, Price2)/Cost)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein