Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi !
Which Field you want to check if there is a 0 ?
Best Regards
Mike Preuss
the expression is like this :
if(columnno()<>0,$(vPerFormula)/$(vPerFormulaTotal),$(vPerFormula)/$(vPerFormulaPartialSum))
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?
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)