Sum of column from slice based on enumlist multiple selections generates a 0 value

[OptimiX_XcrY]

Hi there ,

I have a slice based on a Enumlist filter that is set in a one row table. The slice shows the correct data when I select one or more options from the enumlist filter.
I also have a virtual value (in the same one row table) that calculates the sum of [quantity] column from that slice.

The sum VC formula returns a correct value when the slice is based on only one selection from the enumlist filter , but returns 0 when the slice is based on multiple selections from the same filter.

Please , point me in the right directions to fix this sum value. At the moment , it makes no sense to me , since the slice shows the correct data in all instances.

The sum VC is simple , sum(facturianalize[Cant.]) . Same happens when I sum another column , even with “select” included.

Thank you

[OptimiX_XcrY]

No worries. Thank you very much. I’m a bit crazy when I can’t understand something,even when it works

I am now learning the Split() , because I avoided it all my life :))

[Suvrutt_Gurjar]

That haystack is for single enumlist , so just a plain list. I believe when we do Table[Enumlist] it is list ot enumlist that requires flattening.

I think we may request @Steve , for his insights.

[OptimiX_XcrY]

It could be, I get it now.

Yet, in my app, a let all dropdowns but one to blank (so it skips the IN, and select two options in only one enumlist , and the SUM errors.

[Steve]

Suvrutt_Gurjar:

That haystack is for single enumlist , so just a plain list. I believe when we do Table[Enumlist] it is list ot enumlist that requires flattening.

Correct.

[Steve]

Suvrutt_Gurjar:

The below video

Looks like the video didn’t make it into your post.

[Suvrutt_Gurjar]

Steve:

Looks like the video didn’t make it into your post.

Hi @Steve ,

Are you unable to see the video? I can see it in the post. Maybe it has to do with making it public share permissions.

[Steve]

[Suvrutt_Gurjar]

Thank you @Steve .

Strange , I see it in the post.

I have attached it again.

[Steve]

After investigating further, it’s my browser configuration. Sorry for the false alarm!

[Suvrutt_Gurjar]

No problem Steve. Thank you for your confirmation on list of list understanding as well.

[Julio35]

Hello everyone, 

I had the same problem (total sum from slice wasn't working when more enum list selected) and i would like to show my solution hoping this will help who is struggling with the same problem 🙂 

I was already using Split in the filter and the slice was actually good (and the total sum), however, when selecting multiple enum list values, the total sum was set to 0 (while the slice was still good). 

I fixed the problem by changing the "Item separator" of the enum list in the filter to "," (without quotation marks) and using split as follows: split(text, ","). Before this change, the enum list was saved as follows: "item1 , item2 , item3" (with blank spaces between commas). To sum up, i fixed the problem by removing blank spaces in the enum list. 

I hope this helps. 

Thank you

[XcrY]

I had to use the SPLIT() , use the formula in a VC in the main table , and use that VC to slice the table. Don't know why, but it seems to work. 

if(

and(
[DataDoc]>=any(setarianalize[datastart]);
[DataDoc]<=any(setarianalize[datafinal]);
If(isblank(setarianalize[x1]);true;In([NUME PRENUME];split(setariAnalize[x1];",")));
If(isblank(setarianalize[x2]);true;In([Departament];split(setariAnalize[x2];",")));
If(isblank(setarianalize[x3]);true;In([categorie];split(setariAnalize[x3];",")));
If(isblank(setarianalize[x4]);true;In([articol];split(setariAnalize[x4];",")));
If(isblank(setarianalize[x5]);true;In([filiala];split(setariAnalize[x5];",")));
If(isblank(setarianalize[x6]);true;In([beneficiar];split(setariAnalize[x6];",")));
If(isblank(setarianalize[x7]);true;In([Catalogat premium etc?];split(setariAnalize[x7];",")));
If(isblank(setarianalize[x8]);true;In([apare Neincasata?];split(setariAnalize[x8];",")))
);
"da";"")