Forum Discussion

MauriceMecowe's avatar
MauriceMecowe
Icon for Resolver II rankResolver II
7 years ago
Solved

IF statement in measure

I’m trying to compare the Turnover per ID (OID) from 2 systems. If they don’t match the difference is calculated with a measure as in the picture below. I would like to add another measure that does ...
Need Help
Show and Tell
Tips and Tricks
  • Cmcmahan's avatar
    Cmcmahan
    7 years ago
    MatchFlag = IF( [Delta Turnover Detailed] = 0, "Match", "No Match")
Cmcmahan's avatar
Cmcmahan
Icon for Resident Rockstar rankResident Rockstar
7 years ago

What's the circular dependency?

MauriceMecowe's avatar
MauriceMecowe
Icon for Resolver II rankResolver II
7 years ago

I entered this formula 

= IF( [Delta Turnover Detailed] = 0, "Match", "No Match")

Maybe because i'm referencing a measure which is also calculated on this table.