About jaddaffon

Hi Sir @vignesh,   Thank you for the reply. I have applied a part of your solution. But instead of the formula in Month Picked, I made use of the ITEM(Time) formula to compare the time period to the boolean checker. Then I introduced an IF function to check if it is within the time period. Thank you for this!    @rob_marshall Thank you also. The community has been very helpful throughout my Anaplan experience.     ... View more

Hi @lindascott    Thanks for this. I was still able to take the training since the changes weren't that far from the instructions in the existing training materials. Hope to see more improvements in the future as our business is looking on exploring New UX as our new dashboard for our clients as it is more intuitive and modular compared to the existing dashboards that we have in Anaplan. Thanks for the prompt response!     ... View more

HI @ArunManickam  Sorry for the late revert. This worked perfectly. Already applied it to our model for allowance computation. Thank you very much for your help!   Kind regards, Jad Daffon ... View more

Hi Sir @ArunManickam,   The time period that i'll use as reference is formatted as time period (months). Is there a way to this months similar to the date format that you have provided?   Kind regards, ... View more

@LipChean_Soh @Jitendra.Vishnolia @DavidSmith    Thank you David for this. I will add these to my review as well. Yes I see now how I can implement this properly to remove hard references.   Thank you all for your help! Greatly appreciated. I will reference all of your points and links for my upcoming presentation for this.   Kind regards, Jad ... View more

Hi @LipChean_Soh,   Thank you for this thorough explanation. I now understand how ALM would benefit us specially in the future to take into account improvements and expansions. So what i'lI do is check all the lists of the models and tag the production lists being used then change the formulas that has direct references into something dynamic. This will take time but I understand now how crucial this is.   Thanks again for the prompt response!     ... View more

Hi David,   Thank you for the tip with the direct references. I'm now trying to reference using lookup so I can tag the Model State list into a production list but I'm having a hard time figuring out the correct formula.   What I did is I referenced the model state line item of my module from the Current Model State property of my list (Based on the Model State list that I created as well). I then made three line items in my module (one for each model status [Maintenance, Production, Unlocked]). My problem is I can't figure out the lookup formula that I should put into these 3 line items to avoid direct references. ... View more

@aakash   @DavidSmith    I was able to apply both of your answers. I created a list named model states that houses the different states. I changed the data format of the model state property from text to list with reference to the model states list. I then proceeded creating a module that references the model state property and created 3 line items for the different states then applied the corresponding formula which looks like this:   IF Current Model State = Model State.[Specific Model State] THEN 1 ELSE 0   It works! Thanks to the both of you for your help. Just one quick question. What would be the effect if I tag the model state list I made as a non-production list? ... View more