Hi. I have an app to pull budget data from connected excel table, do some calculations, then display on screen.
In app preview, it works no problem. But the published app doesn't show the calculation results. It just shows 0.00.
Other answers talked about turning off Explicit Column selection preview feature - I tried that but it didn't make a difference.
On the left is the preview, then on the right is the published version. I have tried clearing cache, restarting, saving and republishing the app, no change.

Can anyone help? Thanks