Please describe

[suvechha_b]

Expression : if(columnno()<>0,$(vPerFormula)/$(vPerFormulaTotal),$(vPerFormula)/$(vPerFormulaPartialSum))

Not getting the if(columnno()<>0,,) and vPerFormula expression as well.

vPerFormula = sum({$<TranType = {$(vAmountType)},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}>} Amount)

Please if any body explain me.. will be helpful

[qlikview2015]

Hi !

Which Field you want to check if there is a 0 ?

Best Regards

Mike Preuss

[suvechha_b]

the expression is like this :

if(columnno()<>0,$(vPerFormula)/$(vPerFormulaTotal),$(vPerFormula)/$(vPerFormulaPartialSum))

[qlikview2015]

You want to check if the ColumnNo is null.

if(columnno()<>0,                         $(vPerFormula)/$(vPerFormulaTotal),$(vPerFormula)/$(vPerFormulaPartialSum))

But you have to write a field in to the brackets i think, or?

[suvechha_b]

It might be , if ColumnNo is null.

Please also help me in the following expression :

vPerFormula = sum({$<TranType = {$(vAmountType)},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}>} Amount)