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.
LinkedIn
Twitter
