Set Analysis - not show zero

[#1]

Hello all,

in the image below you see that the sales at 20-02-2016  of articlenumber 284188. The expression Sales ( sum(salesprice*transactionquantity)  showed as €0,0.

But this must be €235,0 (i contacted with my sales colleague). how can i set my expression to turn the €0,0 into the value of expression Sales sum(salesprice*transactionquantity) ?

Thanks all!

[luciancotea · Accepted solution]

Add the price as dimension, after the date and post the result back.

[avinashelite]

is it the complete expression your using ?? or a part of the expression

[sunny_talwar]

We can't be sure of why it shows as 0. Can you may be share a sample?

[alexandros17]

You could try with

sum(salesprice)*Sum(transactionquantity)

but I think that for the day 20/02/2016 there is a combination of data that exclude salesprice or transactionquantity so it's better to check data.

Let me now

[#6]

Hello Allesandro,

if i use sum(salesprice)*Sum(transactionquantity)

the expression show a €0,0.

[#7]

Hey Lucian,

se the screenshot below. Still the sales price is €0,0.

[#8]

Hello Sunny,

Here you are. please check at the sheet NOS Articles.

thanks !

[luciancotea]

So, the sales price is 0. Fix that.