This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Good morning,I was trying to generate a sequence of 36 base number for
my purchase orders and came up with this expression that transform a
decimal value stored in a number type column into a 6 digit string
number in base 36: INDEX(LIST("0", "1", "2"...
Hello all,for a unique list of tags {AHU-1A, AHU-1B, AHU-1C, AHU-1D,
AHU-1E, AHU-1F, AHU-2A, AHU-2B} I want the list of IDs, it can be any
ID.For example if the ID is the row number the list will be: {1, 4, 5 ,6
,7 ,9, 10, 11}Is it posible?
I have a virtual column [Related childs] with the formula
REF_ROWS("Childs", "Parent ID").The Childs table has a virtual column
that calculates the total for each row called [total price]I want to use
the sum() function to sum the [total price] of th...
I want to go from this table called input data:Equipment IDEquipment
TagEquipment
Quantity2gwiw7v20aA18qwqvlpq5tuA19o0u89o0vz8A14ao71gh8bj2A23jy817lgucyA22zpriey2q5aA31d3thik7iadA41idog9b3sb4A54ji6it51tnuA553tjbshvtczA66To
this table called Equipment...
"Is the [Related...] the system-generated VC, and have you modified it
in any way?"yes it is, and I have not modified it in any way."Does it
produce the same list of key value, or list of [total price] values, as
the equivalent SELECT expression does...