Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
njreardo
Contributor III
Contributor III

Order of operations is off/producing wrong result

I'm doing (a - b) / b but it's giving me the wrong result. Am I writing it correctly? I want to do a - b first and then divide it by b. Ex (Sum([field 1]) - Sum ([field 2])) / Sum([field 2])

3 Replies
pathiqvd
Creator III
Creator III

Hi Nicholas,

  Your expression Is correct. Please share your full expression.

(Sum(A)-Sum(B))

/

Sum(B)

Regards,

its_anandrjs

It seems right but try this ways

=( Sum ( [field 1]   -  [field 2] ) )  / Sum ( [field 2] )

Regards

Anand

vipingarg23
Creator
Creator

Expression is fine. Please share your data if you can.