Forum Discussion

difrenkel's avatar
difrenkel
New Member
8 years ago
Solved

calculating NPV

I want to compute XNP for two projects, each with its own discount rate. I have two tables:  - tblCashFlows with clomns: date | project | values  - bplRate with two column: project | rate   Form...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi difrenkel

     

    Try one of these to get the rate

     

    Calculate(values(tblRate[Rate]),Filter(tblRate,tblRate[Project]=SELECTEDVALUE(tblCashFlows[Project])))

     

    OR

     

    LOOKUPVALUE(tblRate[Rate],tblRate[Project],SELECTEDVALUE(tblCashFlows[Project]))

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi difrenkel

 

Try one of these to get the rate

 

Calculate(values(tblRate[Rate]),Filter(tblRate,tblRate[Project]=SELECTEDVALUE(tblCashFlows[Project])))

 

OR

 

LOOKUPVALUE(tblRate[Rate],tblRate[Project],SELECTEDVALUE(tblCashFlows[Project]))