Not Equal to Expression

[ryanfoster84]

hi i have a variable and it calculates ADV for the latest quarter and it looks like this:

=sum(

{$<

  [Quarter] = ,

    [Quarter Number] = {$(vMaxQuarter)},

    [Opportunity Age] = ,

  [Month Name] = ,

  [Account Manager Full Name] = ,

  [Year] = {$(vPreviousYear)},

  [Country] = {"United States","UNKNOWN"},

>}

Volume)

/

Max(total

{$<

    //[Month] =  {$(vMaxMonth)},

    [Quarter Number] = {$(vMaxQuarter)},

  //[Month Name] =,

  [Year] = {$(vPreviousYear)}

>}

[Business Days QTD])

but i need country to be NOT EQUAL TO United States but am struggling on how to do it. any help would be great

[sunny_talwar]

May be this:

=Sum(

{$<[Quarter] = ,

    [Quarter Number] = {$(vMaxQuarter)},

    [Opportunity Age] = ,

  [Month Name] = ,

  [Account Manager Full Name] = ,

  [Year] = {$(vPreviousYear)},

  [Country] -= {'United States'}>}

Volume)

/

Max(total

{$<

    //[Month] =  {$(vMaxMonth)},

    [Quarter Number] = {$(vMaxQuarter)},

  //[Month Name] =,

  [Year] = {$(vPreviousYear)}

>}

[Business Days QTD])

Update: This will exclude 'United States' from the numerator expression. Is this what you want?

[ryanfoster84]

let me test now

[sasiparupudi1 · Accepted solution]

as per your condition,

[Country] = {"United States","UNKNOWN"}

you are indicating that the country should be only united states and Unknown.

if you do not want united states as a country , that means you only want the countries that are unknown?

if you want to exclude certain countries, you could do

[Country] ={'*'}-{'United States'}

hth

Sasi

[ryanfoster84]

hey both answers are correct many thanks