Using two variables for expression

[#1]

Hello guys,

i want to create a expression between two excisted variables.

1.   vGrossSales =                    sum(TransactionQuantity*SalesPrice)
2.    Netto_Return_Value =                  sum(GrossValue-DiscountValue)

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

[sunny_talwar]

Are you creating the variables in the script or through variable overview on the front end?

[#3]

Front End

[trdandamudi]

In the variable overview you create the below variable:

vNettoSales = ( vGrossSales - Netto_Return_Value)

Then in your charts you can use it as =$(vNettoSales )

[avinashelite]

try like this

vNettoSales = vGrossSales - Netto_Return_Value

or

vNettoSales= sum(TransactionQuantity*SalesPrice) - sum(GrossValue-DiscountValue)

[#6]

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

[avinashelite]

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

[sunny_talwar]

Or use variables with parameter:

Variables with Parameters

[trdandamudi]

Your expression is wrong. Can you share a small sample please...