I am attempting to create a boolean calculated column "Type" below:
|Date||Val1||Val2||Abs Value Diff||Type|
My current calculation is below, and it is outputing the following results: What am I doing wrong to get double the amount of rows expected in this case?
Type = IF(sum(ABS Value Diff) > 0,"MisMatch","Match")
|auditDate||ABS Value Diff||Type|
It seems the [auditDate] and [Type] are in two different data tables. Do they have a proper relationship? Can you share a sample?