Expression

[#1]

Hi,

I need to make a calculation in my dashboard.
Do I need to make an expression and what's the best possible solution for the following case.

ex.

Omschrijving                         Sum

------------------                         -------

1. Verkopen                           500

2. Indirect productiekosten      200

3. Directe kosten                   100

4. Algemene kosten               500

Now I must calculate:

nettobedrag = sum(verkopen) - sum(indirect productiekosten)

bruto marge = nettobedrag - sum(Directe kosten)

I'm new and I don't know the syntax in QV.

Regards
Tim

[#2]

Hi Tim

look at att sample qvw file

[#3]

Thanks for the helpful answer, but

Omschrijving                         Sum

------------------                         -------

1. Verkopen                           500

2. Indirect productiekosten      200

3. Directe kosten                   100

4. Algemene kosten               500

after the calculation it must be:

Omschrijving                         Sum

------------------                         -------

Nettobedrag                           300

Bruttomarge                          100

4. Algemene kosten               500

[#4]

Hi,

You can either do it on Load process, with calculating it on the script side or in your chart with set analysis.

Could you plase share an example? Because you just put the numbers but to answer we need to know what based these numbers are? Are they monthly dimensioned or Order based?

Thanks