Multiple field sum

[manideep78]

Dear Community,

I have field called Item. This Item is an Island

Again Each Item is a Separate field.

Ex:

If I select Item Ball, I need Sum(Ball) =30

If I select Item Pen, I need Sum(Pen) = 70

If I select both Ball and Pen, I need Sum(Ball)+ Sum(Pen) = 100 or Sum(Ball+Pen) =100

like wise if I select all the items, I need sum of all the items to be added.

How can I achieve this?

Thanks in advance.

Regards

Manideep

[sunny_talwar]

Try this for your 7 Item concern:

=Sum($(='['&GetFieldSelections(Item,']+[', 999999)&']'))

[sunny_talwar]

Try this for the 0 concern may be:

=RangeSum($(='Sum(['&GetFieldSelections(Item,']),Sum([', 999999)&'])'))

[CELAMBARASAN]

Try this, it will give you desired result I guess

=$(='RangeSum(' &Concat('Sum([' & Item &'])', ',') & ')')

Hope it helps

[manideep78]

Perfect sunindia‌

Thanks

[manideep78]

Actually, the second one resolved both.

[sunny_talwar]

Awesome

I am glad it worked.

Best,

Sunny

[manideep78]

Hi sunindia,

Now I want to put this expression in alternate states like

Original Expression:

=RangeSum($(='Sum(['&GetFieldSelections(Item,']),Sum([', 999999)&'])'))

using Alternate states:

=RangeSum($(='Sum({AS_NoSel * $}['&GetFieldSelections(Item,']),Sum([', 999999)&'])'))

I tried the second expression, But not giving the exact result.

What's wrong in the above expression?

Thanks & Regards

Manideep

[manideep78]

Is there a way we can add the Alternate states in the above expression