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:

Material Status:

LK_Bvfsku List:

Masterdata Module:
