If cell is blank show no value

[Anonymous]

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]

[Hariharan_R · Accepted solution]

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