Forum Discussion

Craigc3814's avatar
Craigc3814
Regular Visitor
4 years ago

Filter If Formula

I have this formula as a column so that I can slice data using it. I need the formula to only calculate when the Curr Phase column = Planning. I know it is simple but I cannot get it

 

PlanningChg2 = IF(OR(MSD_ALL_CAP_TRANS_BAC[Dollar Diff]>500000, MSD_ALL_CAP_TRANS_BAC[BudgetChgall % difference from BudgetChgBase]>.5),"Yes",IF(OR(MSD_ALL_CAP_TRANS_BAC[Dollar Diff]<-500000,MSD_ALL_CAP_TRANS_BAC[BudgetChgall % difference from BudgetChgBase]<-.5),"Yes","No"))

Filter
if

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Craigc3814  - would this work?

     

     

    PlanningChg2 = 
    IF ( MSD_ALL_CAP_TRANS_BAC[Curr Phase] <> "Planning",
    "No",
    IF (
      OR ( MSD_ALL_CAP_TRANS_BAC[Dollar Diff]>500000,
           MSD_ALL_CAP_TRANS_BAC[BudgetChgall % difference from BudgetChgBase]>.5),
     "Yes",
     IF (
        OR( MSD_ALL_CAP_TRANS_BAC[Dollar Diff]<-500000,
            MSD_ALL_CAP_TRANS_BAC[BudgetChgall % difference from BudgetChgBase]<-.5),
        "Yes",
       "No")
    )
    )

     

    • Craigc3814's avatar
      Craigc3814
      Regular Visitor
      4 years ago

      When the Curr Phase is Planning I need it to do the rest of the calc, when it is not planning I need it to say "No"

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        sorry replace = "Planning" with <> "Planning".