Syntax to use variables that contain Set Analisys in Dimension and Expression in linear table

[Anonymous]

Good afternoon everybody.

I have the following situation.

I finished the following variables that contain a formula in extenal file.(formule.qvs)

SET @FattProgCYTLM = "sum({<FlagCYTLM={1},Year=,YearID=,YearMonth=,EconomicYear=>}$(varFatturato))";

In the script I read the file. Everything works correctly

SET _DIRINCLUDE = "..\INCLUDE\";

$(Must_Include=$(_DIRINCLUDE)formule.qvs)

I can not use that variable (@FattProgCYTLM) in Dimension and of a table Expressions.

In the DIMENSION (COD_CLI) of Linear table, I select customers (COD_CLI) that the value of the formula is > 0

and in the expression thevalue ($(varFatturato)) must be to the customer sales that satisfy the condition indicated in the dimension.

Not I find the correct syntax.

You can give a support ??

Thank you so much.

[sunny_talwar]

We might be able to offer better help if you can provide a sample to look at. Would you be able to provide a sample to look at what you are doing?

[Anonymous]

I have a difficult to send an example. The application is very substantial. I would only like to know is the correct syntax to use variables, that contain Expression, of Dimension and in the in Expression in a linear table.

practical example.
For customers who have the field: FatturatoAnnoCorrente > 0 and FatturatoAnniPrec = 0

In correct the syntaxin Dimension :

=Aggr(if(FatturatoAnnoCorrente > 0 and FatturatoAnniPrec = 0, CLI_COD&'-'&CLI_DES),   CLI_COD )

To have the Sales of customers in the Expression of table is correct the syntax:

sum({<FlagCYTLM={1},Year=,YearID=,YearMonth=,EconomicYear=, FatturatoAnniPrec={0}, FatturatoAnnoCorrente={">0"}>}$(varFatturato))

Thank you

Manuel