About ToddKavanaugh

@rob_marshall   I am looking for some guidance on how to do weighted averages based on a selected amount of weeks? Our call center planning is in need of looking at weighted averages based on a variable amount of weeks For example, a user selects the number of weeks they want to average the results by and based on that amount of weeks, there is different weighting by percentage.. Module: Made up of 2 lists(Weekly Percentages; Number of Weeks Average') and 1 line item (Percent)     I have set up a list for 'Number of weeks average' to select the # of weeks we want to average, and a list for 'weekly percentages' for the % needed for the corresponding week..  i.e. if you choose a 5 week average, week 1 will be weighted at 24%, week 2 at 22% and so on..If you choose 6 weeks, those percentages change according to what percentage is in the module Can assist me with this? Have any examples or can you point me in the right direction? I am drawing a blank and I feel like it shouldn’t be that complicated... ... View more

I am trying to take a 3 part Unique ID with delimiters and separate it at the delimiters. I can achieve this for the first 2, but not the last part.   ex: 123-0542-236541 LEFT(NAME(ITEM(LIST)), Delimiter in Item Name - 1) = 123 RIGHT(NAME(ITEM(LIST)), Delimiter in Item Name) = 0542 Delimiter in Item Name = FIND("-", Item Name) Item Name= NAME(ITEM(LIST))   I can not parse the digits after the last delimiter. Anyone? Is it possible? Any Ideas on how to parse it a different way?    ... View more