Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like:
Sum({<year={2014}, document={1,2,3}>} Sales)
define
vSALES = documents = {1,2,3}-{4]
Now use as below
SUM({<vSALES, year = {2014}>}Sales)
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
Can you upload sample app?
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.
Hi try something like this:
In Expr:
Sum($(vCondition) Sales)
and in Variables
vCondition
{<year={2014}, document={1,2,3}>}
sum(<year = {2014}>}$(=vSALES)) How to write expression
I tried, this is working fine
=sum(<year = {2014}>}vSALES)