[_input] Issue

[PCV_Tech]

In a bot I tried to assign a decimal value to an [_input] (Decimal type)

Sum(select(Timesheets[hours], in([columnA], list(item1, item2) + [_thisrow].[enumlistofText])))

The important part here is the enum list passes in the editor and gives me the expected value but on a report generated by the bot this only sums the values that matched item1 and item2. I have tried several permutations of splitting and concatenating the enumlist but it seems to not recognize the values within. 

Also tried to just assign text([enumlistofText]), which again passes in the editor and shows the textual value even though it's a decimal type but once I tested that on the report it was blank.

[WillowMobileSys]

I assume by "report" you are referring to a PDF template used in generating a document?  

If so, then the big question is what does [_THISROW] refer to.  This will depend on your Bot implementation. 

Can you show us the Event from you Bot so we can see how you have it configured?  Is that Event configured to operate on rows of a specific table?  Does that table have [enumlistofText] as a column?

If all that checks out as okay, theoretically the expression should work in a template.   So I would test by creating a Virtual Column to which you assign the list part ONLY = list(item1, item2) + [_thisrow].[enumlistofText].  Confirm that it IS getting assigned the expected SINGLE list of items.  If you have to adjust it, then make the same adjustment in the template and retest.  If you get the VC showing the list as you expect and it still doesn't work in the template, then replace the list portion of the expression in the template with the VC and try that.

[PCV_Tech]

---

After all my testing and the additional testing because of your ideas (Thank you for your response by the way) it seems i strayed away from using [_thisrow-1]. (The formulas came copy pasted right from an existing template hence the use of the "-1")

I instead switched to [_thisrow] because what i thought was a minor glitch was actually caused by a column named the same in the two tables i was dealing with. So alas, i renamed the column in my report table and reinstated [_thisrow-1] in the formulas passed through [_input] on the Bot and it all works. 

Also surprised because i didn't know that [_thisrow-1] was required in this particular scenario.