LOOKUP by specific text

AtzdGr8
AtzdGr8
in Modeling

hi everyone. i would lookup only which is awarded or awarded (PO) in my contract details. how to do it in LOOKUP function?

'Contract Price'.'Final Contract Price'[LOOKUP: ContractDetails."Awarded","Awarded (PO)"]

Answers

  • SriNitya
    SriNitya

    @AtzdGreat
    create a boolean line item where only "Awarded" or "Awarded (PO)" is true and then in another list formatted line item formulate to display only Awarded or Awarded (PO) by using boolean then you can refer the line item in Lookup

Categories