Set Analisys - minor operator

[warrentk80]

Good morning everyone, I would need to use in a set analysys formula, the minor operator.

for example I have to take in a text box all the sales from the beginning year to the selected month.

the forum that I use for the sale of the month is:

sum ({1 <[MonthSale] = {'$ (= V_MeseSerie)'}, Sales)

how do I insert the minor operator?

Thanks 1000

Andrew

[YoussefBelloum]

Hi,

what do you mean by this "..all the sales from the beginning have to the selected month." ?

what is the content of this variable V_MeseSerie?

[warrentk80]

sorry, if I select may I have sales from January to May, if you select July sales from January to July, etc .....

Thanks 1000

Andrew

[YoussefBelloum]

ok, how did you declared your V_MeseSerie variable ?

[warrentk80]

V_MeseSerie is the month of the selected date.
in the set analysis I do not know if I can control between fields, so I use a variable

[YoussefBelloum]

Supposing that your MonthSale field values are this: 1, 2, 3, 4, 5 ... you will need something like this:

=Sum({<[MonthSale] = {">=$(=GetFieldSelections([MonthSale] ))"}>}sales)