Forum Discussion
jeroenterheerdt
Microsoft Employee
Microsoft EmployeeShare your thoughts on visual calculations (preview)
Hit "Reply" and let us know what you think of visual calculations! To learn more about this feature, please visit the blog post or our documentation. Here are some areas that we'd like to hear ab...
I need to format that new calculation. make it currency. I'm not seeing how to do that.
thanks
- jeroenterheerdt
while FORMAT works, it changes the output to text so you can't use it for further calculations. We will add support for formatting soon.
- lbendlin
Super User
Use FORMAT as the output of the calculation.
The only issue with this is that FORMAT returns a text value, which means that if you want to do something like add data bars to the column as a cell element, nothing happens. Which is to say, we need to be able to do more than just format the data in the column; we need to be able to control its data type as well.
- jeroenterheerdt
agreed - that is coming.
