Format on Conditional
Rows (diff1,diff2) are basically differences that should show 0 if (r1-r2) or (r2-r3) equals 0
Now the tricky part is I need to have either a number or a 0 in the rows (curentR, currentS) as that gets added on to diff1 or diff2.
Is it possible to have zeros for row - curentR and currentS, and yet Not show it - zeros for them don’t appear in those rows -
Again – curentR, currentS rows will either have a number or a zero in value. BUT these rows can’t have nulls in place of zeros,
( as they are added up to other complex formulas and throws #Value errors…)