ques

[Dolly123]

how to calculate the profit , margin,current sales vs previous sales,sales growth  in Qlik sense ?

anyone can reply me as formula for dashboard

[micheledenardi]

Sum(Profit) 
Sum(Margin)
Sum(Sales)

Sorry but QlikCommunity cannot help you on these topics since profit/margins/sales depends from how your company is setted.

Please face these arguments with your controlling department in order to understand where pick the correct data from your ERP and how to built the correct formulas.

[Dolly123]

i want only formula ?

[micheledenardi]

Sales is generally the [Invoiced Amount].

Margin is generally obtained by [Revenues-Costs].

Profit is generally [Revenues]- [Expenses].

As i wrote you need to discuss with your controlling/sales department.

We cannot write you the exact fomulas for 2 reasons:

1) We don't know your company's financial rules.

2) We don't know how your datamodel is.

[Dolly123]

i want only formula basics

[micheledenardi]

Sales is generally the [Invoiced Amount].

Margin is generally obtained by [Revenues-Costs].

Profit is generally [Revenues]- [Expenses].

[Dolly123]

thanks

[micheledenardi]

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.