hello All ,
I thank each one of you for your valuable suggestion.
I came to find a solution for my Problem. for some reason QLIKSENSE was ignoring the formatting of the item cost even though it was done in the script. so my workaround was to force the item cost format while fetching from the database as I am fetching data from Oracle .