Calculating saving from 2 columns with 0 (Zero) or with no value(blank/null) values in it.

[Kaalu007]

Hi All,

From Target (Column 1) & Actual(Column 2), I am trying to calculate Saving (Column 3).

Saving in possible below senarios, and below to this image my attempt of power query custom column. 

= if [Target] = [Expense] or [Target]=null or [Expense]=null or [Target]=0 or [Expense]=0 then null else [Target]-[Expense]

[Ahmedx · Accepted solution]

plse try this

[ 
t = [Target]*[Expense],
to = if t <> 0 and  t <> null 
then [Target] -[Expense] 
  else null][to]
------- or -----------

[
t= [Target]*[Expense]?? 0 ,
to = if t> 0 then [Target]-[Expense] 
   else null][to]