Highlighted
New Contributor

Sum or count the number of recurring entries in a list

Hi everyone, first post and hoped that someone could help me as I have been racking my brains to try and do this

 

So I have a list which is called tbl_masterdata, within this list is a field called BVFSKU which is text formatted. I have the BVFSKU's in a list (LK_BVFSKU) and this is used to populate tbl_masterdata on an import. 

There is also another field in tbl_masterdata called Material Status based on a formula and returns either of the entries "DELISTED", "STOCKED", "RUNDOWN" or "NEW VINTAGE". 

What I would like to do is have all a list of the BVFSKU's with a sum to find how many instances of them are delisted, stocked, rundown or new vintage. There is also currently an if else statement against each entry on a module called masterdata module to mark each status so if material status = "DELISTED' then 1 else 0 but this is at material level and not BVFSKU.

Really hope you guys can help!

 

tbl_masterdata list:

 

Screenshot 2019-11-17 at 14.36.22.png

 

Material Status:

 

Screenshot 2019-11-17 at 14.36.56.png

 

LK_Bvfsku List:

 

Screenshot 2019-11-17 at 14.37.24.png

 

Masterdata Module:

 

Screenshot 2019-11-17 at 14.46.38.png

2 REPLIES 2
Super Contributor

Re: Sum or count the number of recurring entries in a list

Hello,

 

Can you make the Material Status as a list formatted line item. By this way, you can create a module dimensioned with BVFSKU and Material Status and calculate the count by using SUM function.

 

Thanks

Arun

New Contributor

Re: Sum or count the number of recurring entries in a list

Thanks @ArunManickam this really helped