num sum with mathematical signs

[#1]

Hello,

I am working on the following formula

=num(sum({<SalesChannel={'Internet'},Type_Forfait={'Forfait*','Offre spé*'},Type={'Réserver logement'}>} PersonNights),'#'&chr(39)&'##0', '.', chr(39)) 

it is regarding hotel reservations. in the following formula, i am counting only Reservation from INTERNET and with the Type_forfait = Forfait, offres spé...

what if now i would to count the hotel reservations which NOT including Type_forfait = Forfait, offres spé.

i was just thinking of using <> instead of = after Type_forfait...but it is not working..

thanks for your help.

JP

[c_gilbert]

I think you would just put a minus symbol before the equals sign after Type_Forfait.

[#3]

=num(sum({<SalesChannel={'Internet'},Type_Forfait=-{'Forfait*','Offre spé*'},Type={'Réserver logement'}>} PersonNights),'#'&chr(39)&'##0', '.', chr(39)) 

[#4]

thanks for your comments...i did not find this solution do you know why we can not use <> different ??

[#5]

=num(sum({<SalesChannel={'Internet'},Type_Forfait-={'Forfait*','Offre spé*'},Type={'Réserver logement'}>} PersonNights),'#'&chr(39)&'##0', '.', chr(39))

Should work.

I would also have a look this thread, as it explains about the different operators you can use

Set Analysis: syntaxes, examples

Hope that helps

Joe

[#6]

thanks a lot great help