Help! Crystal formula field to calculate VAT?

[Sarah.Debnam]

Hi all,

Could someone please help me with my below query? (It has been driving me nuts for a few days now! )

I currently have a formula field in a report that calculates the individual VAT for a list of values. The formula is as follows- ({Orders43.OR_NETT}*0.15) I have also tried ({Orders43.OR_NETT}/100*15). The problem I have is that when I export this report and total up the column which contains all the individual values in excel it comes to 8883.6045 HOWEVER if I export this report without the formula field and do this manually in excel in its place the value is 8883.3945. To recap- Total when crystal works it out is 8883.6045 and total when worked out on Excel is 8883.3945.

I really hope someone can help me please?

Thank you in advance

PS. Hello all I'm new here!

 

[Sarah.Debnam]

38 views and no-one can help? oh dear more complex than I thought then

 

[simon4amiee]

have you fiddled with the format of the formula feild, that may help, I dont have Crystal no more, so cant check it out for you sorry, failing that use a calculation that does return 15%, might mean dividing by 1000 or something, sorry im not much help!