If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
formulas set on value in a text box
I have a query which i run for monthly reports i can get all the data but the
client wants it broken down into different vat groups the one group is 0.14 and one that is set to 0 with the total it works perfectly that all the stuff balances but he wants to see these two vat rates seperate on sales how would i formulate a formula that i dont have to build in additional subreports or change the query but only by a criteria in the sum formula e.g. =Sum(([SumOfQuantities Sold]*[Unit Price])+([Unit Price]* ([VAT Rate]=0.14) *[SumOfQuantities Sold])-([SumOfQuantities Sold]*[Discount])-([Adhoc Discount])) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Selecting text boxes in PP | David Bowers | Powerpoint | 23 | November 5th, 2005 10:41 PM |
Formulas dealing with text data | Bagia | Worksheet Functions | 6 | June 20th, 2005 10:29 PM |
Ideas On Producing Envelopes & Labels For Data | RNUSZ@OKDPS | Setting Up & Running Reports | 0 | April 28th, 2005 03:22 PM |
Help with design | Ronnie | Database Design | 6 | March 12th, 2005 02:53 PM |
Outline | Renee Hendershott | Page Layout | 2 | December 25th, 2004 02:49 PM |