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")
MauriceMecowe's avatar
MauriceMecowe
Icon for Resolver II rankResolver II
7 years ago

Tha's unfortunately not possible, since it'll say I have a circular dependency...

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.