Problem with queries

[salvuccicarlos]

Hello! I’m having some trouble showing a variable from my database.

So the query is this one (with the SUM of saldo_e on saldos table):

And my page should show me the data obtained from the query

But is not working

Though while debugging the inspector shows me the variable I wanted.

If I take of the SUM option on the query, like this:

The variable is shown:

[raymantle]

@salvuccicarlos

Try giving the column an Alias.

Ray.

[salvuccicarlos]

How do I do that? What is an alias?

[brad]

In your very first screenshot where you set SUM, you will see a third column for Alias. Just enter a name in there such as totalsum or something.

[raymantle]

Your welcome.