Forum Discussion
Combining Two Columns (Calculated) But Getting Circular Dependency Error
I have the existing formulas below in two separate columns that I want to combine into a new single column but I am getting a circular dependency error (picture attached) :
First:
3.Errors = if(and('Timesheet'[Activity Type]="Control",calculate(Sum('Timesheet'[2.Walkthrough])+sum('Timesheet'[2.Design])+SUM('Timesheet'[2.Interim])+SUM('Timesheet'[2.Rollforward])+SUM('Timesheet'[2.Annual])+SUM('Timesheet'[2.Remediation]))<>calculate(sum('Timesheet'[Hours]))),"Errors","")
Second:
0.BlankProcess = if(and('Timesheet'[Activity Type]="Control", 'Timesheet'[0.Adj Process]=BLANK()), "Errors", "0")
I want to combine the two columns, into a new column to basically say if the first column is equal to "Errors" and the second column is equal to "Errors", then "Errors" and if not then Blank.
hi DMB90 ,
try change it to:
3.Errors =
IF (
AND (
'Timesheet'[Activity Type] = "Control",
([2.Walkthrough]
+ [2.Design]
+ [2.Interim]
+ [2.Rollforward]
+ [2.Annual]
+ [2.Remediation] )
<> [Hours]
)
"Errors", ""
)p.s. try not to use CALCULATE in calcualted columns, context transition can spoil the calculation easily.
2 Replies
hi DMB90 ,
try change it to:
3.Errors =
IF (
AND (
'Timesheet'[Activity Type] = "Control",
([2.Walkthrough]
+ [2.Design]
+ [2.Interim]
+ [2.Rollforward]
+ [2.Annual]
+ [2.Remediation] )
<> [Hours]
)
"Errors", ""
)p.s. try not to use CALCULATE in calcualted columns, context transition can spoil the calculation easily.
Thank you. This resolved my issue. Thanks for the tip to avoid using CALCULATE as well.
