Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 (Duplicate Values as you see below).
Can anyone help me how to fix these duplicate values? Attached is the qvd and qvw file
thanks
Bhavesh
try this:
=If(Num_Month = '$(vPreYearLastMonth)' and Year = '$(vPreYear)', 0, Sum(AGGR(Updated_OEC_Budget, Cost-Code)))
@jduenyas that expression works for Total, but when I change the Engineering_Area the value becomes 0
It seems like one of the joins or the logic in the load script is causing duplicate records. Your data model may need to be changed to better suit your analysis.
As a test, try removing the NCC_Code column and see if the duplicates are removed. Looks like you are getting a row for each distinct value of NCC_Code.