Help - variable declaration

[#1]

Dears,

I've the following expression in the Script Editor.

var_mid_lat=min(Latitude)+(1+var_lat_offset)*((max(Latitude)-min(Latitude))/2)'

Basically this expression sets the "average" latitude for all items listed in my excel spreadsheet, but my doubt is:

I want to have the same expression calculating the same thing but only for NAC Customers.

And my spreadsheet have 3 main collumns, that are: Latitude, Longitude and Region.

And I've 4 regions that are: NAC, EMEA, ASIA and LATAM...

So, how could it be done?

Could you give me an example?

Thanks you so much

[#2]

var_mid_lat = Sum({$<Region={'NAC'}>}(min(Latitude)+(1+var_lat_offset)*((max(Latitude)-min(Latitude))/2)))

Hope this will help you

[CELAMBARASAN]

Hi,

     You can use set analysis for this.

     var_mid_lat=min({<regions={'NAC'}>} Latitude)+(1+var_lat_offset)*((max({<regions={'NAC'}>} Latitude)-min({<regions={'NAC'}>} Latitude))/2)'

Hope it helps

Celambarasan