Hello, I have a table named “GastosDiarios” with columns “Fecha” (Date), “Categoria” (Category), and “Valor” (Value). I’m trying to perform various SQLite queries and display the results in different labels. For example:
To show the total for the current month:
sqlCopy code
SELECT * FROM GastosDiarios WHERE strftime('%m', Fecha) = '12';
Another query to display the sum of values grouped by category:
sqlCopy code
SELECT Categoria, SUM(Valor) as totGastos FROM GastosDiarios GROUP BY Categoria;
“Thank you, Taifun! What I need to display are totals and calculations through queries similar to that one. For example, one value would be the total sum for the month, another the total sum of values with the ‘income’ category, etc. Then, perform some calculations such as dividing the total income by the number of days in the month. That’s why for each query, I want to display the result in a label. Only the value, so I would use, for example, two combined labels; one would be ‘Total Income:’ and in the second label, the value, for example, $100,000. I almost achieved the goal, but it shows the result like this: (TOT 100000), and I don’t want to display the field name or the parentheses.”
It would really help if you provided a screenshot of your relevant blocks, so we can see what you are trying to do, and where the problem may be.
To get an image of your blocks, right click in the Blocks Editor and select “Download Blocks as Image”. You might want to use an image editor to crop etc. if required. Then post it here in the community.
