I have a simple formula in a column which adds the values in adjacent columns.
Is there a way where I could suppress the display when the values add up to zero (because the adjacent columns are empty)?
I should perhaps add that this CalcManager is on a WinGrid if it isn't obvious.
OK, never mind :)
if( [count1] + [count2] + [count3] > 0 , [count1] + [count2] + [count3] , "" )
Hi,
It is my understanding that you have resolve your question by adding the above if condition. Please let me know if you have additional questions regarding suppressing zero values. I will be happy to assist you further.