![]() |
#1
|
|||
|
|||
![]()
I have several conditional formatting statements stacked. I want to suppress the line break if the evaluation is blank.
{IF { MERGEFIELD Eval1} > 0 "{MERGEFIELD Value 1}" ""} {IF { MERGEFIELD Eval2} > 0 "{MERGEFIELD Value 2}" ""} {IF { MERGEFIELD Eval3} > 0 "{MERGEFIELD Value 3}" ""} current output Not Zero 1 Not Zero 3 desired output Not Zero 1 Not Zero 3 |
#2
|
||||
|
||||
![]()
Put all the fields on the same line and Include the line break within the quotes e.g.
{IF { MERGEFIELD Eval1} > 0 "{MERGEFIELD Value 1}" ""}{IF { MERGEFIELD Eval2} > 0 " {MERGEFIELD Value 2}" ""}{IF { MERGEFIELD Eval3} > 0 " {MERGEFIELD Value 3}" ""}
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
|||
|
|||
![]()
Thank you for the response! I have tried several variations of this method based on the pinned tips and tricks. It is still problematic in the event the all the evaluations have >0 values or not. I have tried the method you purpose and have also tried to nest the IF statements, but I am ending up with values on the same line or still some with line breaks.
My data is CAT1 CAT1Value CAT2 CAT2Value CAT3 CAT3Value CAT4 CAT4Value desc1 $10.00 desc2 $0.00 desc3 $15.00 desc4 $20.00 desc1 $10.00 desc2 $10.00 desc3 $0.00 desc4 $0.00 desc1 $0.00 desc2 $20.00 desc3 $0.00 desc4 $0.00 desc1 $20.00 desc2 $3.00 desc3 $10.00 desc4 $10.00 desc1 $10.00 desc2 $0.00 desc3 $0.00 desc4 $10.00 I am trying to get the first row evaluation to write: desc1 desc3 desc4 unless I am misunderstanding your recommendation, the results are desc1 desc3desc4 |
#4
|
||||
|
||||
![]()
The line breaks go where I have shown ¶ in the following
{IF { MERGEFIELD CAT1Value } > 0 "{ MERGEFIELD CAT1 } { MERGEFIELD CAT1Value }" }{ IF { MERGEFIELD CAT1Value } > 0 "¶ " }{IF { MERGEFIELD CAT2Value } > 0 "{ MERGEFIELD CAT2 } { MERGEFIELD CAT2Value }" }{ IF { MERGEFIELD CAT2Value } > 0 "¶ " }{IF { MERGEFIELD CAT3Value } > 0 "{ MERGEFIELD CAT3 } { MERGEFIELD CAT3Value }" }{ IF { MERGEFIELD CAT3Value } > 0 "¶ " }{IF { MERGEFIELD CAT4Value } > 0 "{ MERGEFIELD CAT4 } { MERGEFIELD CAT4Value }" }
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#5
|
|||
|
|||
![]()
Perfect! I was missing the sequence of the conditional statements. Thank you for taking the time on the explanation!
|
![]() |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Section and Line Break leaving line on previous page | Stonehands99 | Word | 5 | 08-13-2019 08:59 PM |
![]() |
Aminbhr | Word | 2 | 10-22-2017 06:36 AM |
Interchange line break and paragraph break shortcut keys | skan | Word | 2 | 01-20-2017 03:50 AM |
Field Code Help - Remove Line Break | zonixa | Word | 0 | 09-08-2016 10:59 AM |
![]() |
nmss18 | Word | 2 | 09-11-2014 06:07 AM |