peter_mcanena 
Reactions
-
Re: Lookup on text format
You can do this but you need to convert the text to a list-formatted line item first. (I'm assuming the Index line item is the name of the item in your list.) Let's say the list you're looking up is …1 -
Re: How to detect with 1st date with condition
In that case, use this modified formula for Parts Inventory.Shortage Date:IF Inventory < 0 THEN START() ELSE NEXT(Shortage Date) And this modified formula for First Shortage Date.Shortage Date:Par…1 -
Create Hierarchial list using import
Hi, I am trying to create a list as shown in the attached image. Here i have'nt created the seperate list for 5804 (which is like parent list). To avoid sparsity & size constrain, i am trying to …2 -
Custom Sum without Introducing New Dimensions
When you perform a custom sum (either because you've switched off the line item's sums or because you're calculating a partial sum or using a different summary method), the usual method is to define …5 -
Goal Seek
Given a complex function y = f(x), you sometimes need an inverse function that finds the value of x required to produce a given value of y. In Excel this can be done using the Goal Seek feature, but …6
