Sum Selected ListBox values

[Anonymous]

Hi,

Can you tell me how to show sum of selected list box values in TextObject.

Screenshot is here,

regards,

[Anonymous · Accepted solution]

Hi,

I think you should write just this: sum(distinct [Name_Field_in_listbox])

KR

Elena

[engishfaque]

Dear Elena,

Sum(Distinct(FieldName)) will return the sum of field not list box selected values.

Kind regards,

Ishfaque Ahmed

[Anonymous]

The question is: "how to show sum of selected list box values in TextObject".

If these values are selected, sum function will return the sum of only the selected values...

Maybe, didn't I understand the question?

Thanks,

Elena

[Anonymous]

Hi,

Take sum(field_name) in text box.

HTH

[Anonymous]

=sum(distinct(value)) will return sum of selected values in listbox

'value' is column which is used in list box .