Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

If cell is blank show no value

Hi all   Is there an addtional creiteria i can add to the measure below if "forecast FTE" is blank the "Actual v Forecast delta" row shows Blank with no values.        Actual V Forecast De...
Need Help
  • Hariharan_R's avatar
    Hariharan_R
    4 years ago

    Hi Anonymous 

    Try the below.

     

     

    IF(ISBLANK('EUP-Forecast FTE'[Forecast FTE]), BLANK(), 'EUP-Forecast FTE'[Forecast FTE] - 'Amentum & Sub Con Excludin Leavers'[Average Actual FTE])

     

    Thanks

    Hari

    Did I answer your question? Then please mark my post as the solution.
    If I helped you, click on the Thumbs Up to give Kudos.

    My Blog :: YouTube Channel :: My Linkedin


Hariharan_R's avatar
Hariharan_R
Icon for Solution Sage rankSolution Sage
4 years ago

Hi Anonymous 

Try the below.

 

 

IF(ISBLANK('EUP-Forecast FTE'[Forecast FTE]), BLANK(), 'EUP-Forecast FTE'[Forecast FTE] - 'Amentum & Sub Con Excludin Leavers'[Average Actual FTE])

 

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin