Forum Discussion

joep78's avatar
joep78
Helper III
6 years ago
Solved

Lookup function (=RELATED) including IF is Blank function

 hi There,   I have a quick question, I get information from another table with the function  =related and this works as expected. How ever, I also have empty lines (that are logical) but I want a ...
Need Help
  • tex628's avatar
    tex628
    6 years ago

    Try this,

    ReportingCurrencySpotRate = 
IF(
RELATED(BaseAccountingCommitment[ReportingSpotRate]) = BLANK() , 1 ,
RELATED(BaseAccountingCommitment[ReportingSpotRate])
)
tex628's avatar
tex628
Community Champion
6 years ago

Try this,

ReportingCurrencySpotRate = 
IF(
RELATED(BaseAccountingCommitment[ReportingSpotRate]) = BLANK() , 1 ,
RELATED(BaseAccountingCommitment[ReportingSpotRate])
)
  • joep78's avatar
    joep78
    Helper III
    6 years ago

    Thanks for this quick reply and solution, works as expected, great! kudos for you!