All,
I hope you will be able to help me with this one, I am having issues pulling data from a data table whose source is a collection.
I have a collection setup called "addSoftware" that contains a series of ID#s and a set of numbers called "Pressure Options"
I am successfully pulling this collection into a data table and performing some computations on the data using AddColumns. However, I am unable to use the LookUp command to pull a single value out of the table, even though I can pull data directly from the collection using LookUp. The forum is not allowing me to post screenshots just yet, so I have put some code snippets below. Any ideas?
This code pulls successfully from the collection and adds a few columns to a new table called "DataTable2"
AddColumns(addSoftware,"multiplied",Pressure_x0020_Options*5, "prev ID", If(ID=1,0,ID-1))
This code pulls a value successfully from the collection
LookUp(addSoftware,ID=2,Pressure_x0020_Options)
This code fails to pull data from "DataTable2" - regardless of whether it is a calculated column or not. I have tried something similar on data tables that aren't pulling directly from a collection and am having a similar issue.
LookUp(DataTable2,ID=2,Pressure_x0020_Options)
Cheers and have a good weekend,
-Zac
