seymatas1 · Certified Master Anaplanner · 
-
Re: Dynamic Fake Weeks to Fake Months?
Why not give codes to the months and use those in your module instead of using ISFIRSTOCCURRENCE and RANK formulas? Am I overlooking something? Seyma 🌷🙂1 -
Re: Dynamic Fake Weeks to Fake Months?
https://www.youtube.com/watch?v=hD7Wt4wcxwM In this video, they set it up as numbered lists but as @nvilkko mentioned, there is no need to set up dynamic time as numbered lists.1 -
Re: Module to List Data import
Hi @Soumyajit It sounds like you're trying to create a list using a Sys module. I suggest following best practices instead. Importing directly from a module to a list usually isn’t the best appr…1 -
Re: Help Needed with COUNTIF Equivalent Formula in Anaplan
Here is how I created the same COUNTIF logic in Anaplan: COUNTIF(Anaplan) line item's formula: IF 'Meals-Self?' THEN IF 'IFO Name&Transaction Date' THEN 1 ELSE 0 ELSE Att…1 -
Re: Help Needed with COUNTIF Equivalent Formula in Anaplan
=IF(F3="Meals-Self",IF(COUNTIF($O$2:O2,O3)>0,0,1),E3) does the following: Checks if the value in column F - Attendance is "Meals-Self". (F3="Meals-Self") If true, it …1
