About zdlee

zdlee

I would like to get the averages for a line item using prior year month values. I can use the formula below but I don't like the idea of hardcoding. Is there another way I can do this without hardcoding? The current formula I have is: LAG(<source LI>,12,0)+LAG(<source LI>,24,0)+ LAG(<source LI>,36,0) / 3

zdlee · ‎08-18-2022

I have a calculation currently in the "Usage Base Forecast" line item. I want it so that if a user checks off the "Use Previous Month Final Forecast", it moves the final forecast from last month to next month. For example, if the boolean is checked off for July, it will take the "Usage Final Base Forecast" and move it to August. I'm thinking that I need a POST or OFFSET formula?

zdlee · ‎01-12-2021

That worked! Thank you!

zdlee · ‎01-12-2021

In module 1, I have a count for resolved and unresolved. In module 2, I would like the total for unresolved items and resovled items. How do I do this? I know in Excel it would be a simple sum formula. Module 1: Module 2: Thanks!

zdlee · ‎09-24-2020

I have a list that has Meetings, Food, and Cars. These 3 items should both be under domestic and international as parents. When I try to enter them in manually they just move parents and when I import they it gives me a warning. I tried to create codes for them individually as well. Would I need to use a numbered list?

About zdlee

How can I get the average of months for prior year...

How do I move one value to the next month?

Re: How do I get the total from one module to anot...

How do I get the total from one module to another?

How do I get my list with the same names but diffe...