Forum Discussion

Sadr_Hoda's avatar
Sadr_Hoda
Frequent Visitor
3 years ago

Pick data from measure

Hi,   I am preparing a forecasting P&L, BS and SOCF position, however, I am stuck in BS.    For each forecasted year, I have created a "measure" which is based on prior year data multiple by grow...
Need Help
v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

Hi Sadr_Hoda ,

Is [@*FCY] a measure? How do you know it's not picking any data, have you write the formula out seperately to see? Could it be because the measure [@*FCY] has nothing to do with table NL_Structure-BS?

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Sadr_Hoda's avatar
    Sadr_Hoda
    Frequent Visitor
    3 years ago

    Yes [@*FCY] is a measure, use to create P&L for Fiscal current year. I have dobule check it but not showing any result. Moreover NL_Strucutre_BS is a mapping table which is link with Trial balance table.

     

    Do you know any other way to create forecasting P&L, BS and CF?

     

    Please let me know, You can reach me @ 00974 55745337.

     

    Thanks in advance.