Calculation of not fed cells
Posted: Fri Mar 22, 2013 12:39 pm
Hello, community!
As far as i know in case if cell value is asked by some rule or direct view construction, cell value is calculated independently from fed status of the cell. But unfed cells are not calculated when their values are asked indirectly (when some rule is taking value from consolidated cell). So is there any way to totally switch off all calculations in unfed cells?
This may be usefull for not to write megatonns of IF(<...condition...>, 0, <...formula...>)
As far as i know in case if cell value is asked by some rule or direct view construction, cell value is calculated independently from fed status of the cell. But unfed cells are not calculated when their values are asked indirectly (when some rule is taking value from consolidated cell). So is there any way to totally switch off all calculations in unfed cells?
This may be usefull for not to write megatonns of IF(<...condition...>, 0, <...formula...>)