Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

formula syntax

Helo,

I've got 2 values.

Value 1 = Sum (Aantal)
Value 2 = (Sum (Aantal1))/ Max (Maand1)

Value 1 returns 150
Value 2 returns 250

Now I want Value 1 - Value 2 = -100

I've tried (Sum (Aantal)) - (Sum (Aantal1))/ Maand1) but does not work

Sum

(Aantal) - Sum (Aantal1)/ Maand1 also does not work



2 Replies
shumailh
Creator III
Creator III

It has to be work, can you share us the file

Not applicable
Author

You missed max

Sum (Aantal) - Sum (Aantal1)/ max(Maand1)