run the bot in debug mode…have a breakpoint on assign and then check the locals panel to see what values are present and use immediate panel to execute the query and check the values from there…this would help you determine the issue if there is any in the data or formula
cheers