How to use SET - simply

[sculptorlv]

Can't get with simple thing. Please help.

I defined one variable

SET Price_Criteria = '2.84';

Now I opened Text Object ... and use following value:

=$(Price_Criteria)  

     and I get no values....

How can I use my simple variable?

[reddy-s]

Hi Ruslans,

set value = 'Year = 2015';

data:

LOAD * INLINE [

    ID, Year, Product, Quantity

    1, 2015, C, 10

    1, 2015, B, 6

    2, 2015, A, 8

    2, 2015, E, 3

    3, 2015, C, 7

    1, 2014, A, 10

    2, 2014, A, 1

    3, 2014, A, 7

];

infox:

load *,

if ( $(value),1,0) as flag;

load * Resident data;

drop table data;

Try some thing like this!

[jonathandienst]

=Sum(If($(No_Contract),1, 0))