Wording in formular

[#1]

Hi,

I have two questions about the right formula in QlikView:

1: If I want to calculate 20 % less for the following formula, what´s the right wording:

sum(Umsatz_EUR_Kleffmann)

2: We have a source with a Price list. The wording for the Price is

only(ppr_preis)   here I can see the Price for the actuall year

I want to show the price for the following year (Price for 2015 in 2014). What`s the right wording?

Thanks for your answers.

Ulrich

[Gysbert_Wassenaar · Accepted solution]

I hope I understood your questions correctly.

1. sum(Umsatz_EUR_Kleffmann)*0.8

2. only({<Jahr={2015}>}ppr_preis)

[#3]

Thank you very much!!