About sarah.esguerra

sarah.esguerra · ‎12-03-2020

numbers will be uploaded quarterly but in YTD figure, I need to plot the quarterly numbers. Q1 YTD will be imported in Q1 and I need to save it in my Q1 column Q2 YTD will be imported in Q2 containing both Q1 and Q2 numbers, I need to retain the Q1 above and get the number/result for Q2. By this time, columns for Q1 and Q2 will have values. then Q3 and then Q4..so on.. I only thought of copying the line item (YTD) to another line item (snapshot), I think there would be a better solution on this one. Thanks!

sarah.esguerra · ‎09-10-2019

this is what the body of my mailto looks like: but it should like this instead: to make the link visible and clickable to the recipients. Do we have any workarounds to do this? Note: here is my mailto formula: MAILTO("Send to Approver 1", " ", "", "", "Anaplan notification", "https://us2a.app.anaplan.com/core10145/anaplan/framework.jsp?selectedWorkspaceId=8a81b00e67191af001672d4db52616de&selectedModelId=2EB5EDD76EF64A668505BEC98CC32A5F") Thank you so much! Best regards, Sarah

sarah.esguerra · ‎08-30-2019

This met my requirement, thank you!

sarah.esguerra · ‎08-07-2019

Yes already thought of it, but my requirement needs much more complex one. Thank you for the response.

sarah.esguerra · ‎08-06-2019

Hello, I have this "Employee Profile" module with dimensions Time and Employee list as shown below: Immediate Superior Line item is a list-formatted line item, that uses also "Employee List" as format. Is it possible to make another module using this data, to show all employees reporting to each Immediate Superior every month/quarter? I am now trying to create an "Employees per Team" module but cannot proceed because it seems that I need to use Employee List Twice for the said module? Note: I did not created an Employee List with hierarchy since the employees are fluid, moving from one team to another frequently hence just created a single employee list and just created a module with time dimensions to include all employee details each period. Hope you can help me on this. Thank you. Best regards, Sarah

sarah.esguerra · ‎07-30-2019

It worked!!! This is the result that I need! So now I can delete my QTR modules, and use this instead. It may not be beautiful to look at, as you mentioned, but this is the result I need so thank you 🙂 If I thought of any enhancement on this, I will let you know right away 🙂 thank you! this helped a lot 🙂

sarah.esguerra · ‎07-27-2019

I will try to do this setting and I hope it will work, I will get back to all of you as soon as I get the result I need. Thank you!

sarah.esguerra · ‎07-25-2019

Meantime, what I did is, I created a Time range without Quarter totals and use it to calculate every month data then created another module to calculate quarter data. But I keep on trying to do a single module with Quarterly totals because I think that my current idea is not the best practice.

sarah.esguerra · ‎07-25-2019

Here is the idea of the requirement: MinMax Days Range = Metric Score table applicable (via lookup) No. of accounts Due = Number of accounts needs to be processed No. of accounts processed = Number of accounts actually processed Ratio = Number of Processed over Number of due ratio Metric Score = Corresponding Metric Score per day range in the MinMax Days metric table (via lookup) Final Score per Metric = Metric Score multiplied by ratio (to get the weighted score depending on the ratio and metric score) Final Score per Metric SUM per month is okay since its their score for the month, but per Quarter/Time Summary, the score should be still at Metric Score * Ratio for the quarter hence the FORMULA in Time Summary

sarah.esguerra · ‎07-25-2019

It still doesn't provide the needed result. I am thinking that Summary in Anaplan has its limitation/very limiting so I might result to making another module with Quarter only time dimension but I am not sure if its the best practice to do, Here is the result after editing the summary:

sarah.esguerra · ‎07-25-2019

@VIGNESH.M here is the result after changing Metric Score to Metric Score to Sum,Time:Max

sarah.esguerra · ‎07-25-2019

Hi, I need to have a SUM summary for a line item but it doesn't add up but results to zero instead. I attached a screenshot for reference. Thank you.

sarah.esguerra · ‎05-31-2019

Hi, anyone who can help on formula "ABS"? I need to get the absolute value of the line item, but Anaplan seems to round off the item. Any notes on this? Thank you. Below is the screenshot for sample:

sarah.esguerra · ‎05-31-2019

Hi @anirudh We do not have selective access on both models, also users have same access for now. But during import, as if no data are available to map then that error will occur after.

sarah.esguerra · ‎05-28-2019

Hi all, Anyone encountered this error? We cannot import from one model to another because this error occurs every time. Kindly see below:

sarah.esguerra · ‎05-20-2019

Hi, I have 3 modules, all sharing the same dimensions (period, transaction# and employee list). The first 2 modules contains line item "metric" both with output type list (same list), I need to see all the data in all line items of module 1 and module 2 - it should be consolidated in module 3. In module 3, it has the same dimension and line item metric with output type list but I cannot combine all data in it. I tried to use "+" function to combine data from module 1 and module 2 but it cannot push through, there appears to have an error in using "+", as I used before this comes in handy when consolidating data with number output types. Do we have any workaround so I can combine the data altogether? Thank you! Sarah

sarah.esguerra · ‎04-16-2019

Hello, Is there a way to reset the number generated in a numbered list? Also, is there a way that we can sort a list in alphabetical order after import? Thank you!

sarah.esguerra · ‎04-10-2019

This silly question solved my query. I am thinking way too far than how simple the solution should be. It took one silly question for me to think 🙂 THANK YOU again for this @DavidSmith, my module now calculates all the hours I need 🙂

sarah.esguerra · ‎04-10-2019

Hi, thank you @DavidSmith for the response. I also thought of that, that Anaplan might read it as 0.7 instead of 0.70 but the TAT Hours list looks like this (list name and code in 2 decimal places, with zero in the end): Also now, I tried to look up using number rounded up in 2 decimal place (used Round(Total Hours, 2) formula for it to match the decimal places in the TAT Hours list) but the same problem goes. Hope you can help me with this, THANK YOU.

sarah.esguerra · ‎04-04-2019

Hi all, I have a list named "TAT Hours" and a line item "TOTAL HOURS" that is in number format. I used FINDITEM formula to get the number of hours (TAT Hours) in the list, here is the formula: FINDITEM(TAT Hours, TEXT(IF TOTAL HOURS <= VALUE(NAME(TAT Type.Min Hours[LOOKUP: 'TAT Type1'])) THEN VALUE(NAME(TAT Type.Min Hours[LOOKUP: 'TAT Type1'])) ELSE IF TOTAL HOURS > VALUE(NAME(TAT Type.Max Hours[LOOKUP: 'TAT Type1'])) THEN VALUE(NAME(TAT Type.Max Hours[LOOKUP: 'TAT Type1'])) ELSE TOTAL HOURS)) It gives me the correct result, which is the corresponding "TAT Hours", but I noticed that if I will input any number in line item TOTAL HOURS that ends in zero (0) it will not give any result, just blank. But if I will input any other number that is not ending with zero, it gives back the correct result. I attached a screenshot, wherein the first line item gives the correct result but the next item does not (since it ends with zero) Thank you, Sarah

sarah.esguerra · ‎03-07-2019

Hi @DavidSmith here you go, hope this helps for you to understand my question better 🙂 Thank you!

sarah.esguerra · ‎03-06-2019

Hi @DavidSmith attached is the screenshot, thank you 🙂

sarah.esguerra · ‎03-06-2019

@rob_marshall wrote: @kavinkumar , From the original attachment, I believe the data was at the day level, thus start() would work great. Thanks, Rob yes! start() formula also worked 🙂 thanks

sarah.esguerra · ‎03-06-2019

Yes, the long formula worked. I needed a "per day" date in my line item that's why I didn't used Start () or end () and used the long formula instead. Thanks everyone for the help 🙂 @kavinkumar wrote: Hi @david, The above formula that you mentioned will work only to return 1st and last day of the month. But here the requirement is to get each date across the Time period. @sarahcorrect me if I am wrong!! Thanks, Kavin.

sarah.esguerra · ‎03-06-2019

Another question re TIME DIMENSION. I have this encounter on calculation of working days, when I created a module with PERIOD as line item, the "count" line item formula produces result, whereas, if i use PERIOD as a TIME DIMENSION, the "count" formula in my line item does not produce any correct result. Do you know why if I use a time dimension, the formula should have a different approach?

sarah.esguerra · ‎02-21-2019

How can we do interpolation in Anaplan? I need to interpolate scores from the following criterias: a. Min number with equivalent score b. Max number with equivalent score Thank you!

sarah.esguerra · ‎02-20-2019

Yes, it makes sense to use 2 instead of 1. Thank you so much! 🙂

sarah.esguerra · ‎02-20-2019

Thank you for the response 🙂 appreciated 🙂

sarah.esguerra · ‎02-20-2019

Thank you so much! This helped 🙂

sarah.esguerra · ‎02-20-2019

Hello, Am trying to make a calendar in Anaplan to plot weekdays and holidays. Time dimension for the model is "DAY" and I wanted not to type the dates in each days, but to put a formula instead. What would be the formula to return the "date" of the time dimension to the line item. I tried to use "ITEM(TIME)" but it does not return the date but has an error instead. Sample: If the calendar date in the dimension is Jan 1, 2019, the line item would return 1/1/2019 I attached a screenshot of the calendar module I am working on. Thank you!