Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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?
let me test now
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
hey both answers are correct many thanks