Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
bhaveshp90
Creator III
Creator III

Error in calculating expression

Hello, 

I have a table below as shown below. I have my expression for OEC - Current as 

 

=If(Num_Month = '$(vPreYearLastMonth)' and Year = '$(vPreYear)', 0, Sum(Updated_OEC_Budget))

 

Sum(Updated_OEC_Budget) = 179922+522900 = 702822; but the expression is wrong. 

What is wrong here? Any help is greatly appreciated. I have attached qvw for reference; 

 

1.PNG

Labels (2)
10 Replies
bhaveshp90
Creator III
Creator III
Author

Hi @sunny_talwar, did you able to find the qvd files attached?