Margin % calculatory measure not working

[Anonymous]

Hi,

I tried to make calculatory measure to my table with the following expression but it is not returning values. Can anyone comment what

is wrong with my formula?

num([Division Margin]/[NetSales], '#,#0%')

Thanks,

Petri

[niclaz79]

Hi,

Try this:

num(Sum([Division Margin])/Sum([NetSales]), '#,#0%')

[prma7799]

Missing Sum keyword

Try below

num(Sum([Division Margin])/(Sum([NetSales])), '#,#0%')

[Mark_Little]

HI Petri,

As suggested you are missing your aggregator, When you do any calculations in measures you should add an aggregator, so Qlik know how to calculate your result correctly, I.e. Sum(), Avg(), Max(). What is needed really depends on your data and what you are trying to show.

Mark

[Anonymous]

Thanks all. Problem solved 🙂

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post; not visible in preview) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .