Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

problem with visual descrepncies

Hi, I have a table which is a summary of 234 rows and 6 cloumns (the left one with Actual header) and another one wich is a matrix with user input numbers(Target header in the right). I have a probl...
Need Help
Show and Tell
  • TeigeGao's avatar
    TeigeGao
    7 years ago

    HI Anonymous ,

    Please try to use the IF(....,BLANK(),) to force the blank area display blank(), it will disappear.

    Best Regards,

    Teige

Anonymous's avatar
Anonymous
Not applicable
7 years ago

TeigeGao  Did you note that the right matrix is imported as is from excel? It's not summerized nor pivoted. but the right one is the summary of a matrix of 4 columns and 235 rows! Please reply?

TeigeGao's avatar
TeigeGao
Solution Sage
7 years ago

HI Anonymous ,

Please try to use the IF(....,BLANK(),) to force the blank area display blank(), it will disappear.

Best Regards,

Teige