If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Text appears when the fields are blank
Hi, I'm not sure if I have the right approach to this problem but here
goes: I can have up to 5 sets of fields with each set consisting of 3 fields per record. Some records only have say 3 sets. On the letter each set is a separate line. For the 4th and 5th sets rather than get a supressed row if I simply had one field on its own I end up with some of the text buried within the merge formula. How can I change my approach/formula to make sure rows 4 & 5 are totally supressed please? { MERGEFIELD "M_2Shares" /f ""}{ IF { MERGEFIELD M_2InvestmentName } "cash" " shares in { MERGEFIELD M_2InvestmentName /f ""} valued at £{ MERGEFIELD M_2CurrentValue }" "valued at £{ MERGEFIELD M_2CurrentValue} } Correct displays include: 9,764 shares in Edinburgh New Income Trust plc 1p ords (ENI) valued at £4,064.75 Remainder as Cash valued at £200.00 Using [] to show field data: [9,764] shares in [Edinburgh New Income Trust plc 1p ords (ENI)] valued at £[4,064.75] [Remainder as Cash] valued at [£200.00] Blank lines that should be supressed show: shares in valued at £ which is that same if I had the text part outside the IF statement |
Thread Tools | |
Display Modes | |
|
|