Using “Multi-Value separator: New Line ”, but not showing values equal to zero

HCL Domino Domino Forum
1

I have a table on a form where users enter rows of accounting data. Each row in the table has four fields with the last field being a number. I’m displaying this information in a view that uses “Multi-Value separator: New Line ” in the column. I’m expanding the row height to nine and using the shrink to content option. So, each row in the view can contain several lines of data. I don’t want lines to show in the row if the number field has a value of zero. I hope this is clear.

2

Subject: Using “Multi-Value separator: New Line ”, but not showing values equal to zero.

In your column formula, try something like this:

temp := @if(NumberField=0;“”;@Text(NumberField));

columnList := @Trim(field1:field2:field3:temp);

columnList

3

Subject: RE: Using “Multi-Value separator: New Line ”, but not showing values equal to zero.

It works now. Thanks for the help.

Duane

4

Subject: You can do it like this…

Column1 FormulaBList := Field1 + “~” + Field2 + “~” + Field3 + “~” + @Text(NumberField) + “~”

RowsWZeros := @Trim(@Left(BList; “~0~”));

RepList := RowsWZeros + “~0~”;

FinalList := @If(RowsWZeros = “”; BList; @Trim(@Replace(BList; RepList; “”)));

@Word(FinalList; “~”; 1)

Column2 Formula…

BList := Field1 + “~” + Field2 + “~” + Field3 + “~” + @Text(NumberField) + “~”

RowsWZeros := @Trim(@Left(BList; “~0~”));

RepList := RowsWZeros + “~0~”;

FinalList := @If(RowsWZeros = “”; BList; @Trim(@Replace(BList; RepList; “”)));

@Word(FinalList; “~”; 2)

Number Column formula

BList := Field1 + “~” + Field2 + “~” + Field3 + “~” + @Text(NumberField) + “~”

RowsWZeros := @Trim(@Left(BList; “~0~”));

RepList := RowsWZeros + “~0~”;

FinalList := @If(RowsWZeros = “”; BList; @Trim(@Replace(BList; RepList; “”)));

@TextToNumber(@Word(FinalList; “~”; 4))