Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Every One
This my expression Mesure and I want to show 2,41 in 2015 If any one can help me for this problem.
(sum({1<Marque={'AD'},Year='2015'>}Montant_HT)-sum({1<Marque={'AD'},Year='2014'>}Montant_HT)/sum({1<Marque={'AD'},Year='2014'>}Montant_HT)
Can you share some sample data to look into?
In my mesure I calculated EVOLUTION 2015 ---> (SALES2015-SALES 2014)/SALES2014
BUT AFTER ADDED IN TABLE PER YEAR is show me this normally this value should be contain in rows 2015
Are you missing an extra bracket here?
= (sum({1<Marque={'AD'},Year='2015'>}Montant_HT) - sum({1<Marque={'AD'},Year='2014'>}Montant_HT)) / sum({1<Marque={'AD'},Year='2014'>}Montant_HT)
IF you can provide some sample data or a sample file will be easy to work on it quickly?