Values becomes #available or #error after formaula

Hi All,

I am creating a webi report on SAP universe.

Problem :

Whenever I apply any date related formala on the date field , all the values in the measure becomes #error or #available .

Additional informaion :

it has got say 6 fields like Cusotmer , sales material and Date ( making it one dimension) and Profit , quanity sold and amount as measures.

I created a formaula on date field and added 4 days to the current date.

Now what happens is if I dragged this new formaula object to webi output area all my measures become #error or #un available.

When i remove this newly created formaula from result area , all the values comes back .

This happend also when I wanted to find out the name of the day on a particular date and drangged onto my resultant area.

After this all the measure values in the webi got #error or #available error.

Any help is highly appreciated.

Thanks & Regards,

Anjna Goyal