These examples assume that Time Balance is set to First.
Skip Option |
Example |
---|---|
None |
Jan = 0, Feb = 20, Mar = 25, Q1 = 0 The value of the first child (Jan) is 0, and zero values are considered when calculating the parent value. |
Missing |
Jan = #MISSING, Feb = 20, Mar = 25, Q1 = 20 The value of the first child (Jan) is #MISSING, and #MISSING values are not considered when calculating parent values, so Q1 = second child (Feb), or 20. |
Zeros |
Jan = 0, Feb = 20, Mar = 25, Q1 = 20 The value of the first child (Jan) is 0, and zero values are not considered when calculating parent values, so Q1 = second child (Feb), or 20. |
Missing and Zeros |
Jan = 0, Feb = #MISSING, Mar = 25, Q1 = 25 The value of the first child (Jan) is zero, and second child (Feb) is #MISSING. Because #MISSING and zero values are not considered when calculating parent values, Q1 = third child (Mar), or 25. |