Gross Profit - Number Card - Group By Item Code

1

Need to create a Number card to show Monthly Profit for a trading company.

Created the Number card and added in Dashboard. field Gross profit and function sum

System doubling the gross profit amount, how we can avoid doubling of gross profit.

in invoice wise report Gross amount shows 2 time in UI, but in item Code its not there, still system doubling the amount and showing in screen.

Suggest the option for showing daily monthly and yearly profit in Management dashboard.

2

Same issue
All i did at the end was to make a graph
grouped by item groups (feasible for 3-4 groups only) as UI supports limited display and puts rest to others category.