topic Re: Margin % calculatory measure not working in App Development

Margin % calculatory measure not working

Anonymous — Mon, 30 Oct 2017 08:51:39 GMT

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

Re: Margin % calculatory measure not working

niclaz79 — Mon, 30 Oct 2017 09:36:39 GMT

Hi,

Try this:

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

Re: Margin % calculatory measure not working

prma7799 — Mon, 30 Oct 2017 09:46:17 GMT

Missing Sum keyword

Try below

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

Re: Margin % calculatory measure not working

Mark_Little — Mon, 30 Oct 2017 10:52:27 GMT

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

Re: Margin % calculatory measure not working

Anonymous — Tue, 31 Oct 2017 11:26:01 GMT

Thanks all. Problem solved 🙂

Re: Margin % calculatory measure not working

oknotsen — Tue, 31 Oct 2017 14:05:29 GMT

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 .