Forum Discussion

Chanleakna123's avatar
Chanleakna123
Icon for Post Prodigy rankPost Prodigy
7 years ago
Solved

Condition to be Calculation with Multiples Tables.

  Hi all ,    i'm seeking your strongly support here .  I have W/O Number table , Complete WO ( Which is calculated from another Table ) , Close WO ( Which is calculated from another Table ...
Tutorial Requests
  • Stachu's avatar
    Stachu
    7 years ago

    what is the condition for Not Close? It seems identical to Complete to me. If that's the case this formula should work

    Complete / Close =
IF (
    ISBLANK ( Dummy[Close WO] ),
    IF ( Dummy[W/O Number] = Dummy[Complete WO], "Complete", "In Progress" ),
    "Close"
)
Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
7 years ago

what is the condition for Not Close? It seems identical to Complete to me. If that's the case this formula should work

Complete / Close =
IF (
    ISBLANK ( Dummy[Close WO] ),
    IF ( Dummy[W/O Number] = Dummy[Complete WO], "Complete", "In Progress" ),
    "Close"
)
  • Stachu's avatar
    Stachu
    Icon for Community Champion rankCommunity Champion
    7 years ago

    thanks :)