Discussion board where members can get started with Qlik Sense.
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])
Your expression Is correct. Please share your full expression.
It seems right but try this ways
=( Sum ( [field 1] - [field 2] ) ) / Sum ( [field 2] )
Expression is fine. Please share your data if you can.