About jaddaffon

Well I’m curious how you folks started learning UX design, and what tools you used to learn the subject. I want to learn UX design but I am not sure where to start. Is there any books or online courses I can use to learn the subject. I know it not all about learning the tools but I want the resources to be able to understand the field. Im very picky person and I like to follow a set of instructions when I’m learning new things so if there is a book you can recommend or online courses that go from the main concepts and understanding of UX to the actual design. ... View more

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 @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

@LipChean_Soh @JV271090 @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 @jaddaffon    Ideally, you should get the solution as in the below example. Below example is with 3 different states - A,B,C and with 6 models M1-M6   1. Create an input module where you have model state against your model (Dimension of the module) and a line item with 1 as a number. So the dimension is model and there are 2 line items - Model state and count       2. Your target module with model state as a dimension and count as a line item with the formula as written   Model State Count.Count[SUM: Model State Count.Model State]     The way you are trying to achieve this, 1. You will have to create a module with no dimensions, n(Number of model states) line items with format as model state and values of model state list (A,B,C in my case) in respective line items as below     2. To get the result in 3 different line items now (Count of states A,B,C in my case), you create a module (No Dimension) with 3 different line items and put the following formula pointing to 3 different line items above (Point 1)   Model State Count.Count[SUM: Model State Count.Model State, LOOKUP: 'Lookup1'.Model State A]     ---- Not able to attach the screenshots. Happy to mail it to you ----   Hope this helps   Thanks   ... View more