Hi guys,
Looking for some help. I have a report that takes our lot status field and breaks it up into 3 columns of Reserved, Sold, or Spec. The grand total feature will then total the row count for each community. I am in need of a column that will provide the Spec Ratio, or simply the Spec column of that community row divided by the Total for that row. In the example below I can achieve the outcome with a stacked chart (Aspen Meadows has a 51.4%, which is the 18 spec/35 total). How can I achieve this with a formula to create the column?
Appreciate any help!!
Hi @Ryan OLeary you can definitely show percentages of each LotStatus in this report (using a summary formula with PARENTGROUPVAL function), but they will be displayed in the same cells as record count values, not in a separate column. If you really need a separate column, I'd suggest creating a joined report (one block would only include records of Lot Status = 'Spec', a second block would include all records, and then you could create a formula based on these two blocks).
Please let me know if it helps!
