SET expression with variables

[#1]

Hi all.

I need to use set expression with value variable.

I don't know how i can write this formula

For example i have variable vSALES

it is SALES with documents 1, 2, 3

  sum(<documents = {1,2,3}>}Sales

- sum(<documents = {4}>}Sales

This vSALES

I want to use this vSALES for anather SET

for example

sum(<year = {2014}>}vSALES ???? How to write expression

[senpradip007]

Try like:

Sum({<year={2014}, document={1,2,3}>} Sales)

[MK_QSL]

define

vSALES = documents = {1,2,3}-{4]

Now use as below

SUM({<vSALES, year = {2014}>}Sales)

[#4]

OK its good, but i want with variables becouse my formula for sales have o lot of many part and add 2 set in another for this parts it is not good idea

[senpradip007]

Can you upload sample app?

[#6]

Sorry but real file not, but you can created any file for this situation examples, just i want how use variables in finish set expression.

[Anonymous]

Hi try something like this:

In Expr:

Sum($(vCondition) Sales)

and in Variables

vCondition

{<year={2014}, document={1,2,3}>}

[upaliwije]

sum(<year = {2014}>}$(=vSALES)) How to write expression

[Anonymous]

I tried, this is working fine

=sum(<year = {2014}>}vSALES)