I am working with subitems and am struggling to format the numbers that are displayed in the output. With ‘items’, it is easy to click the summary section and select '$" or “%” for example, however with subitems I can’t seem to see that option.
I read in another thread that you can use the ‘TEXT’ function to display the dollar sign and decimal formatting, but I can’t seem to make it work with dynamic columns.
Welcome to the community & Happy New Year
If i am understanding the requirement correctly
You should be able to use the below formula
Hope this provides what is needed
Let me know if you need any additional help
Many thanks in advance
The problem with the Text function is that, as its name implies, it converts the numeric value to text. Because it is now text, your summary shows 0 (it can’t sum up text values). If you remove the Text function from the formula, you’ll see that your summary will work (without the $ sign) and, of course, you won’t have the $ sign anymore at the subitem level…
Ok, yes I can get the equation to work without the $ sign. So I’m assuming in my case there is no way for the $ sign to be displayed. Multiplying two sub columns for a total and then displaying that total on the parent item.