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;
@sunny_talwar Is this something in the script that needs to be fixed. I have used the solution which you gave before (Link Table and concatenating). Can you tell me how to fix this issue?
I am not sure in which step of the process are you duplicating your rows, but this is def. not happening while creating the link table.... this has to be happening before or after... I am not sure how I can pin point this without being able to reload.. can you share all the qvds needed to reload this dashboard?
thank you @sunny_talwar, Please use the below links for the qvd files