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 Delta FTE = 'EUP-Forecast FTE'[Forecast FTE]- 'Amentum & Sub Con Excludin Leavers'[Average Actual FTE]

 

 

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


1 Reply

  • 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