I have a value from a remote JSON source , with the column name “Energy Saved”.
This is working fine, showing the value 50000
Now i want to show an additional value, based on the value “Energy Saved” , let say the half of it (value / 2)
I created a new column in the same dataset named “co2” .
Column type : Formula , Datatype: Number and the formula " ‘Energy Saved’ / 2 "
I put the variable between quotes, otherwise there are no values available.
The result is always zero (0)
What is the exact formula to use?