Hi, I have a one dashboard in Acumatica 2024 R1 and need to display the value of a calculated Gross Profit field as a percentage. Currently, the calculated field shows as sum of Gross Profit % column in the widget. For example, in my Generic Inquiry I created a calculated Gross Profit % field using a formula like: =(IIf(Sum([ARTran.CuryExtPrice]) = 0, 0, (Sum([ARTran.CuryExtPrice])-([AMProdTotal.ActualLabor]+[AMProdTotal.ActualMaterial]+[AMProdTotal.WIPAdjustment])) / Sum([ARTran.CuryExtPrice])))*100 This displays correctly as a number in GI, but when I add it to the dashboard (KPI or Chart widget), it doesn’t show as a percentage. Can you please advise the best way to calculated Gross Profit % field so that it displays as a percentage based on formula on the dashboard?
