About sarah.esguerra

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   ... View more

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! ... View more

Hi,   I need to get the number of days spent to finish a task. What I have is "Date Start" and "Date End", currently, in excel its a simple Date End minus Date Start and it will give the number of days spent. I tried to convert date to text or number, but it doesn't convert it that way.   How can I do this in Anaplan?   Big thanks! ... View more