I am new to this financial report designer. We are still setting up the system.
I can’t figure out why my report results show only zeroes, when I try to input a formula into a column set to show me each line item’s % of total income. In the Row Set (below) row 0102 is my total Project Income. I want to show Gross Margin as a % of income. Eventually, I want to show each income line as a % of total income and each cogs line as a % of total COGS.
I am not sure if I have the row sets set up properly, but I do have a base row code which is total income.
So, I’m trying to use the “value” field in the column set to divide the row by the base row, but I keep getting an error.
What is the correct formula for the value field? Is something else setup incorrectly in either set to make this work?
COLUMN SET
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/1c4bc8ed-a8e7-4424-9353-58c359120987.png)
ROW SET
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/0d0c8806-6ec2-491e-a618-e14966f43898.png)
Result if I try a validated, but apparently incorrect formula in the Value field on the Column Set:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/982a6ffb-89d4-44b2-9a6d-70c68814bbad.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/ed83d80b-10a6-4ae5-a4fe-f617353d7321.png)
Best answer by Foujan
View original