If cell is blank show no value

Anonymous — Tue, 02 Aug 2022 09:23:53 GMT

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]

Re: If cell is blank show no value

Hariharan_R — Wed, 03 Aug 2022 06:54:36 GMT

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

topic If cell is blank show no value in Developer

If cell is blank show no value

Re: If cell is blank show no value