Hello Onemidia,
My question was:
I want to read the value Energy_Saved (that works fine) and next to it a value based on a formula, example: Energy_Saved / 2 - how to do the last value, the formula?
Question 2:
I want to show a value on the screen concenated with a string (KWH) in the same font.
Now i can use 2 regions ofcourse, 1 for the value and 1 for the string, but can a dataset-value show this as 1 string? (also with a formula)?
Looking at your initial post with screenshots, you don’t want to surround your column name with ".
if say, Col1 is the column remote type
then you add new column, formula type and you want to make calculations on it, then you can just put
Col1 / 2
in the formula in the case of your example.
as for other question from 8 days ago, assuming you have the strings in other columns or some parts you want to add as a string directly there, then you can use formula column and CONCAT mysql to achieve what you need.