Forum Discussion
SP List Format Calculated Field
jonboylib Try changing this line:
"txtContent": "@currentField"to this:
"txtContent": "@currentField.displayValue"Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
jonboylib What is the data type of [Aug-22], [Sept-22], [Oct-22] and Budget field? Can you show us the screenshot of list view with some sample data for these fields & calculated value in Total?
Also, JSON formatting works with internal name of column. So, make sure you are using correct internal name in JSON.
Follow this article to get the internal name of your SharePoint column: How to find the Internal name of columns in SharePoint Online?
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
The data type of [Aug-22], [Sept-22], [Oct-22] fields are Number. Does this make a difference?
I know the internal names of the columns are correct because when I change the data type from Number to Currency it works.
See image below, the calculation is working ok, and the conditional formatting is working ok - The Total column is currently data type Number. I want it to be Currency so I can show the symbol £