Formula in count Condition

[pittouti]

Hello,

i have this formula for a Bar chart:

Count({<[AAA]={'Oui'},[BBBB]={'FR'}>} [XXX])

I would like to integrate this formula into the conditions:

weekname (DateA) = weekname (DateB)

like this :

Count({<[AAA]={'Oui'},[BBBB]={'FR'},weekname (DateA) = weekname (DateB)>} [XXX])

but it does not work

[Anil_Babu_Samineni]

Try like this?

Count({<[AAA]={'Oui'},[BBBB]={'FR'}>} If(weekname (DateA) = weekname (DateB), [XXX]))

[PriyankaShivhare]

may be like this

create field for week

weekname (DateA) as WeekA

weekname (DateB) as WeekB

Count({<[AAA]={'Oui'},[BBBB]={'FR'},WeekA = {"=WeekA =WeekB")}>} [XXX])

or 

create a flag

if(WeekA =WeekB,1,0) as Flag

Count({<[AAA]={'Oui'},[BBBB]={'FR'},Flag = {1}>} [XXX])

Thanks,

Priyanka

[pittouti]

I think I misspoke

il would like the final results

[PriyankaShivhare]

Do a left join

Table1:

Load week,

             NB2

Source tb1

Left join(Table1)

Table2:

Load Week,

          NB

Source tb2

Thanks,

Priyanka