Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
i want to create a expression between two excisted variables.
i would like to create a new variable called vNettoSales from the two variables upstairs. the formule is : vNettoSales = vGrossSales - Netto_Return_Value.
how can i create this vNettoSales variable? any examples?
Thanks in advances!
Greets,
Rega
Are you creating the variables in the script or through variable overview on the front end?
Front End
In the variable overview you create the below variable:
vNettoSales = ( vGrossSales - Netto_Return_Value)
Then in your charts you can use it as =$(vNettoSales )
try like this
vNettoSales = vGrossSales - Netto_Return_Value
or
vNettoSales= sum(TransactionQuantity*SalesPrice) - sum(GrossValue-DiscountValue)
Hello Thirumala,
Thank you. But i have a new challenge and you can see underneath in the picture:
I created a straight table with the labelname 2016 Netto Sales with the folowing expression:
sum({$<Year={'2016'}>}$(vNettoSales ))
unfortunatly i can't see any result in the the straight table. probably a wrong expression?
Thanks!
Rega
Yes your expression is wrong
sum({$<Year={'2016'}>}$(vNettoSales ))
you should have a field to use the set analysis expression
try like this
sum({$<Year={'2016'}>}TransactionQuantity*SalesPrice) - sum({$<Year={'2016'}>}GrossValue-DiscountValue)
if not yielding the right results ..please explain your requirement
Or use variables with parameter:
Your expression is wrong. Can you share a small sample please...