When a member is missing ,then total MTD calculated based on all member is empty

[cognos05]

COgnos DImensional Reporting .

I have a regions dimension where top level regions are Asia, LatinAmerica and so and so .

I am creating a daily sales report and on first I dont know all regions will have values and members will be generated.

so step 1 ,

I create a filter to see if member caption exists

item(filter([DailySales].[Customers SoldTo].[Customers SoldTo].[SoldToRegions],caption(currentMember([DailySales].[Customers SoldTo].[Customers SoldTo]))='L00 - LATIN AMERICA'),0)
Then I create a member on regions dimension

member(Total (Tuple([Full Revenue],currentmember([DailySales].[Items].[Items])) within set set([LACAMCheck])),'LACAM','LACAM')

step 2,

I have created say five members like this and put them in rows.And Now I have a Total for these with expression

Total( CurrentMeasure within set set([US Regions],[LACAM],[Canada],[APAC],[EMEA]))

All regions and it totals if one of members is present or not

step 3 ,

Below this I add an MTD Total , to show the same total for MTD ,since my slicer has daily days, I use complete tuple here

CompleteTuple([Day],currentMember([DailySales].[Items].[Items]),[RegionForMTD],[Full Revenue])

Here the [RegionForMTD] = [US Regions]+[LACAM]+[Canada]+[APAC]+[EMEA].


Now the issue is everything works fine if there is a member matched with filter caption,

but if say LACAM is missing then the MTD Total comes blank and it s not calulating other totals.


so is there a way I can replace this expression in my complete tuple  with Set or other way to calculate mtd total

[RegionForMTD] = [US Regions]+[LACAM]+[Canada]+[APAC]+[EMEA].

Thnaks,
Nithya