I have table "T" where one of its column "TN" is number field where I can enter any number.
I am using this table in another table "A" as Lookup. One of the column "AC" in "A" table is dropdown list connected to "TN" column of Table "T".
I want to show the dropdown as number as per the number entered in "TN" column starting from Zero.
Example, if "TN" number is 4 then dropdown should show 0,1,2,3,4
I am able to get the drop down as per below formula but I am not able to add Zero in it. Any idea how to do same?
Dropdown Items: Sequence(LookUp(T,TS = Dropdown.Selected.Result).TN).Value

Report
All responses (
Answers (