About VIGNESH.M

Hi Sasi,   To make it dynamic, try the below steps   Step 5: Create a module as below,  Mark the boolean as shown above.   Step 6: In Quota subset filter Module, add 2 more line items(PY, CY) and write the formula as shown below. Finally, your filter logic will be this,  IF Filter Test Mod.PY THEN PY ELSE CY   in this way, you can achieve the dynamic filter.   Thanks @LipChean_Soh , I learned something new about line item subset.   ~Vignesh     ... View more

Hi Edward,   Your Role line Item "Applies to" should be Reps L4, not Roles.   Change applies to Reps L4 as shown below.   Role Line item is getting the role of each rep, so it should be calculated at rep l4 level.     ~Vignesh ... View more

Hi Pradeep,   We have the option to apply logic only for a particular version,   Check the Formula scope in the blueprint view.     in this example, I want to write logic only for Forecast version, so I selected "All versions except Actual"     if you see, my Actual version is editable now, the formula I have entered is only applicable to Forecast version   Check this link for more information https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Blueprint.html?Highlight=blueprint%20view#FormulaScope ~Vignesh. ... View more

Hi Karank,   As per my understanding, the source table should be always more than 1 dimension.   if it's 1 dimension, then this is how the grid appears in the import tab.   ~Vignesh   ... View more

Hi,   It seems the date format you set for the line item is incorrect.      If its a model to model import, then it's not necessary to set the date format. Uncheck the Target Date Format, and run the import.     ~Vignesh ... View more

Hi Gregory,   I Assumed your model contains 2 years data, So total quarterly no will be 8(2*4) records.   I created a list as shown below,   Then Create a module with 3 line item and Quarterly Count list to find the quarter, as shown below Formulas in Line item, A = PERIOD(START()) + VALUE(NAME(ITEM(Quarterly Count))) B = Retrieve time period.'Num 2' = Retrieve time period.'Num 1'[LOOKUP: A] C = IF B THEN A ELSE BLANK   In Final Module, pick the data from the "C" line item.   Grid View,   Try this solution.   ~Vignesh ... View more

Hi Vamshi,     What I suggested will load data for one record based on the Item in the filter.    Next time, select the different record and load data for that record only.   Your previous record data will be still the same.   ~Vignesh     ... View more

Hi,   Create a line item(Number Format), then Use the below logic,   Logic,  IF ISBLANK(TEXT(Rank)) THEN 0 ELSE Rank   Rank is my source line item in my example, Rank final is FInal Value. In your example, Forzen TAT is Source.   if you dont want to see "0" in final value, change the zero format to Blank. .   ~Vignesh ... View more

Hi Vardhan,   I have created Reporting List as shown below(Assume there will be 2 reports)   In 1st reporting Module, add 2 line items(Count, Report Name) Count Line Item is Number Format. Count = 1 Reporting Name Line Item is "Report List" Format Report Name= Report 1   In 2ndt reporting Module, add 2 line items(Count, Report Name) Count = 2 Reporting Name = Report 2 Please check the attached Pic below   In your Final Report Module,  Count = Sum the Count in Report 1 by Report Name+Sum the Count in Report 2 by Report Name Amount = Sum the amount in Report 1 by Report Name+Sum the amount in Report 2 by Report Name     You can follow the same method for any count of Report.   ~Vignesh ... View more