Multivalue field

HCL Domino Domino Forum
1

can someone help point me in the right direction with this? i have the multivalue text field (field_1) “new line/new line” that contains the values below. i also have a computed multivalue field (field_2) “new line/new line” that i want to display the values that match and sum them up. i’ve tried everything i know to try, but i don’t know alot about working with multivalue fields. the field is set up with the (item/quantity/total).

field_1 values

document sales/2/50

document sales/3/75

document sales/1/25

plan sales/3/90

plan sales/1/30

proof sales/2/100

proof sales/3/150

this is what i need to display in field_2

field_2 values

document sales/6/150

plan sales/4/120

proof sales/5/250

thanks in advance,

jason

2

Subject: RE: multivalue field

It might not be the most efficient, but you could do something like:

@If(field_1 != “”; “”; @Return(“”));

_t := @Unique(@Left(field_1; “/”));

@Transform(_t; “x”;

@Do(

  _b := @Trim(@Right(field_1; x + "/"));

  x + "/" + @Text(@Sum(@Left(_b; "/"))) + @Text(@Sum(@Right(_b; "/")))

)

)

3

Subject: RE: multivalue field

thanks!

that worked great! i have never seen nor used the @Transform. i sure appreciate your help.

jason

4

Subject: RE: multivalue field

That’s probably because it’s such a new @Function. It’s only been available for 5 years and 4 months now … (not counting beta releases) :wink: