LOOKUP by specific text

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)"]

Tags

Accepted answers

All comments

@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

Quick Links

Can you help?

Unanswered questions

ADO data types - need definitions/explanations
what are these? when do you use them? why one over another? thanks Data types string long float bool date datetime datetimetz
API certificats renewal
Hello Anaplan Community, We are currently facing an issue related to certificate validation and would appreciate your help or guidance. We are getting the following error: Unable to build certificate chain for Cert [subject DN = EMAILADDRESS=********, CN=service account email address, cert serial number = XXXXX; issuer DN…
Time hierarchy filter new ux when brought forward option is turned on?
Hello, Does anyone know any workaround or a solution to be able to enable the hierarchy filter in new ux when the brought forward option is selected in backend? I do not see the above hierarchy filter option if I enable the brought forward for a line item-