Rolling 13 week sum - Formula Calculated column -SharePoint

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3155938%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3ERolling%2013%20week%20sum%20-%20Formula%20Calculated%20column%20-SharePoint%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3155938%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHello%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20need%20to%20calculate%20Rolling%2013%20Week%20value%20in%20a%20SharePoint%20list.%20This%20would%20simply%20be%20the%20sum%20of%20the%20last%20three%20records%20entered%20in%20a%20given%20column%20title%20%22score%22%20which%20is%20already%20a%20calculated%20column%20written%20as%20a%20sum.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EHave%20column%20called%20%22IsToday%22%20that%20is%20a%20date%20picker%20and%20date%20picked%20for%20each%20record%20will%20be%20same%20every%20month.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%20me%20get%20this%20started%3F%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3ENext%20step%20will%20be%20to%20create%20additional%20calc%20column%20that%20multiplies%20the%20%22Rolling%2013%20Week%20value%22%20by%20a%20multiplier%20to%20come%20up%20with%20a%20final%20score.%20Example%3A%20If%20R13wk%20score%20is%20less%20than%204%20then%20multiply%20%22X%20column%20value%22%20by%20.8.%20If%20R13wk%20score%20is%205-6%20then%20multiply%20%22X%20column%20value%22%20by%20.95.%20And%20if%20R13wk%20score%20is%207-9%20then%20multiply%20%22X%20column%20value%22%20by%201.10.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThanks%20all!%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3155938%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Visitor

Hello

I need to calculate Rolling 13 Week value in a SharePoint list. This would simply be the sum of the last three records entered in a given column title "score" which is already a calculated column written as a sum.

 

Have column called "IsToday" that is a date picker and date picked for each record will be same every month.

 

Can anyone help me get this started?

 

Next step will be to create additional calc column that multiplies the "Rolling 13 Week value" by a multiplier to come up with a final score. Example: If R13wk score is less than 4 then multiply "X column value" by .8. If R13wk score is 5-6 then multiply "X column value" by .95. And if R13wk score is 7-9 then multiply "X column value" by 1.10.

 

Thanks all!

0 Replies