Basic Question

[jadams123]

Hi I want to sum all sales but not include a customer type. How do i do that?

I can sum all sales...but not exclude...

=Sum({$<CUSTOMER_TYPE={'*'} - {ITC}>}, 

($<GLYEAR = {$(#=MAX(GLYEAR))}>) AMOUNT )

Thanks,

Joe

[Clever_Anjos]

Probably

=Sum({$<CUSTOMER_TYPE={'*'} - {"ITC"} ,  GLYEAR = {$(#=MAX(GLYEAR))} AMOUNT )

[sunny_talwar]

cleveranjos‌ - You missed the closing >}

=Sum({$<CUSTOMER_TYPE = {'*'} - {"ITC"},  GLYEAR = {$(#=MAX(GLYEAR))}>} AMOUNT)

or even this should work:

=Sum({$<CUSTOMER_TYPE = - {"ITC"},  GLYEAR = {$(#=MAX(GLYEAR))}>} AMOUNT)

[Anil_Babu_Samineni]

joe adams wrote:

Hi I want to sum all sales but not include a customer type. How do i do that?

From this, you are looking this

Aggr(Sum(sales), - [Customer Type])