QS Table Blank out cell if another equals to 0 (Expression needed)

[alemberg]

I am trying to figure out the expression for the following (Reference table screenshot and current Expressions below). If "Curr DY" or "CutoffDY" show up as "-" in the cell, then I want to overwrite what ever shows up in "Chg in DY" to show up as "-" as well in that row. Much thanks in advance for any assistance you may provide.

Current Expressions for each

Curr DY =            If(Avg(debtyieldcurrent)=0,'-',Avg(debtyieldcurrent))

Cutoff DY=         If(Avg(debtyieldcutoff)=0,'-',Avg(debtyieldcutoff))

Chg in DY=        (Avg(debtyieldcurrent)-Avg(debtyieldcutoff))*10000

[Channa]

in  3rd variable dont use direct measures write IF condition

[pradosh_thakur · Accepted solution]

Chg in DY= If(Avg(debtyieldcurrent)=0 or Avg(debtyieldcutoff)=0,'-', (Avg(debtyieldcurrent)-Avg(debtyieldcutoff))*10000)