Kyle 
Reactions
-
Re: Formula for Range of value
Hi Prabakaran, The formula looks like it should work to me other than the names of the list items seem to be slightly different. You can go into the list and select them to ensure that the formatting…1 -
Re: Formula for Range of value
Hi Prabakaran, If you have a line item that has the Age Bucket list and the asset list as a dimension, then you can write a formula like Asset Details List.Counter[SUM: Asset Details List.Age Bucket]…1 -
Re: Can you change a numbered list back to a non-numbered list?
Hi Tim, If it does not affect users, you could restore to ID. Can also take the model offline, revert to history and export what the list is, and then reupload the list after reverting to the current…2 -
Re: List subset by formula
Hi Yoshi, You can create a line item in the module that does not have time as a dimension and use a formula to reference the total value. If you have the 'All Periods' time then you can write a selec…3 -
Re: Formula for blank value in lookup function
Hello, If the open quantity is number formatted, then you would have to write IF Open Qty by Bucket ID.Open Qty[LOOKUP: Bucket ID LF, LOOKUP: SKU LF] = 0 THEN Quantity Reqd ELSE Open Qty by Bucket ID…3
