Garima welcome to the forums! You're post will get more attention if you repost it in the main forums: Forums (This is VizTalk). When you repost you should show us both the formulas you are using, the one that works, and the one that give you an error. I'll bet you're missing a parenthesis. But have to see to know.
Thanks for the forum link and the response. I got it.