-----Original Message-----
Hi There
Many thanks for your help, it is really appreciated. We are now even closer
to a solution!
You correctly guessed what I was trying to do. Your formula works great,
thank you very much. But there is one problem. When I place this formula in
the report footer (it is presently in the orderID footer) it calculates
correctly but and ignores the rounding order up to £10.
It is simply adding all the lines up. I have one order that has two lines:
1 line £5.00
2 line £2.00
Your formula is now rounding the total up to £10 (Excellent). Yet when this
formula is placed into the report footer it calculates to £7. Not quite what
I want. I need £10!!
Many, many thanks for your help!
Ady
I am still a bit confused because you changed the numbers
pertaining to A B and C however, I think what you intend
is that the report shows to normal sums for A B and C (as
you already have it and only if the grnadtotal is less
than 10 you want it th show as 10.
I hope thiis is correct.
you can do that with only a minor change from my previous
suggestion. Use the following:
=IIF(Sum([GrandTotal])<10,10,[GrandTotal])
Hope this helps.
Fons
-----Original Message-----
Hi There
Many thanks for your reply! However it is not quite
working as I
anticipated!!! Let me explain better!
My SUM adds up all the order lines and then produces a
total. For example:
Part A: £10
Part B: £15
Part C: £12
Total: £37
I then requested help because if the Total was less than
£10 it would
display £10. However the problem is that it now rounds up
to £10 on every
order line! I only want the SUM total to round up to £10.
How it works now:
Part A: £5 (It thinks this is £10!!!!!)
Part B: £15
Part C: £12
Total: £37
How I need it to work:
Part A: £2.50
Part B: £2
Part C: £2
Total: £10
Sorry to be awkward. Many many many thanks for any help
and advice given!
Regards
Ady
"Fons Ponsioen" <
[email protected]>
wrote in message
You could do this with
=Sum(IIF([ViewedItemTotal]<10,10,[ViewedItemTotal]))
Hope this helps.
Fons
-----Original Message-----
Hi There
I have a formula in my report that adds up all the
values
of each order:
=Sum([ViewedItemTotal])
However I need a cleverer formula than this! I need a
formula that will do
the above, but if the total value of the order is less
than 10 it needs to
round up to 10. For example if the total order is 7.50
the field needs to
display 10.
Any help would be highly appreciated.
Regards
Ady
.
.
.