Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bazzaonline
Creator
Creator

Dividing by Avg Where

Hello,  I have a table and which has months in the first column and an AVG field in the second,  I need a formula that divides the AVG Month figures by a specific months AVG. 

For example each months Avg Figure divided by the Avg figure for Jan 2020 (202002).

 

Any Ideas?

Labels (1)
1 Reply
StarinieriG
Partner - Specialist
Partner - Specialist

Hi,

try to create the value in a variable, then use that inside the expression.