Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tonyvee1973

    colouring of rows if.......

    Thanks skip, works like a charm. now I just need to work out how I get into the query that the excel sheet runs from :) appreciate the help
  2. tonyvee1973

    colouring of rows if.......

    sorry skip, don't think I can explain what I need properly. If the values in A, B, C and D match the row directly above then I need to colour BOTH rows GREEN If the values in A, B and C match the row directly above but D is different then I need to colour both lines in RED does this make any...
  3. tonyvee1973

    colouring of rows if.......

    hi skip if I leave a blank row 1 as a header row, I insert this formula into row 3 at the end of the data. It shows me TRUE or FALSE if its true then I know the conditions I need match =IF(A3=A2,B3=B2,D3=D2)
  4. tonyvee1973

    colouring of rows if.......

    Hi All Hopefully a quick one for someone but driving me nuts! I have an excel table that I need to compare a row against the row above it. If the row matches exactly I need to colour BOTH rows GREEN If the values in A, B and C match but NOT D then I need to colour both lines in RED. I have...
  5. tonyvee1973

    still seeing supressed values in sum

    Hi Guys and apologies for the delayed response and appreciate the input. Last night I managed to resolve the issue by using different tables in CR. It seems that the where the tables were linked by order number they were producing duplicate values if the records held multiple invoices per order...
  6. tonyvee1973

    still seeing supressed values in sum

    Ok thanks guys, appreciate the assistance. Will take another look at the report to see if I can find a workaround as maybe its better I get the tables linked better to avoid bringing in duplicates anyway and therefore kill the need for suppression :)
  7. tonyvee1973

    still seeing supressed values in sum

    Thanks Skip, appreciate the info but cant get it to work. I place this in a formula and place in the group header but it just divides the qty of the detail line it seems - doesn't sum anything.
  8. tonyvee1973

    still seeing supressed values in sum

    sorry Skip, what do I do with that?
  9. tonyvee1973

    still seeing supressed values in sum

    Hi all Have a report which data has duplicates in that I need supressed. I have a formula (@qty) in the details section and in the section expert area to suppress I have the formula below. //This formula suppresses the Details line //when there are duplicate values contained in the fields...
  10. tonyvee1973

    comparing rows in an excel sheet

    Ah, so I wasn't a million miles away, need to read up on ABS :) Thanks Skip, works like a charm as always, much appreciated - have a great weekend!
  11. tonyvee1973

    comparing rows in an excel sheet

    Just a quick update on this formula (Which works perfectly btw) :) If I wanted to add a tolerance to the match (Instead of a perfect we will accept + or - 6pcs) how do I add this into the formula above? I have tried =IF(AND(A3=A4,B3=B4,D3=D4)<=6,"MATCH","") but that doesn't work - sure I am...
  12. tonyvee1973

    comparing rows in an excel sheet

    Ah ok, thanks all
  13. tonyvee1973

    comparing rows in an excel sheet

    Thank Skip, works like a treat so much appreciated. Huge apologies as didn't mean to appear disrespectful to you guys, just that I tried pasting in from an excel sheet and it pushed all the figures together - thought this may be a nightmare to read in the post. The image seemed much better but...
  14. tonyvee1973

    comparing rows in an excel sheet

    Hi All A little help needed if possible? I have a stocktake and data is being pushed into an excel sheet. Problem is that I need to be able to compare columns A, B and D between a row and the row underneath it - if they all match then put "Match" in an adjacent cell. Some sample data below, any...
  15. tonyvee1973

    Not show suppressed details in sum

    Thanks again for this, however I tried that but no joy. When I put you're formula in the details section of the report, when I right click and choose "Insert" it only gives me the option of field heading and not summary.
  16. tonyvee1973

    Not show suppressed details in sum

    Thanks Charliy but a bit confused on what I do with that formula? I tried pasting it into the @f_qty formula but it errors as cannot point to itself If I try to add as the suppress formula in the details section it errors as needs to be ab Boolean - any ideas?
  17. tonyvee1973

    Not show suppressed details in sum

    Hi ALl Been on this for a day or so now and going around in circles so hope someone can advise? I have a report where in the detail line I have a formula named "@f_qty" - this holds a formula as below: if {SL_TRANSACTIONS.ST_TRANTYPE} = 'CRN' then {ORD_DETAIL.OD_QTYINVD}*-1 else...
  18. tonyvee1973

    cant transfer calls to a certain handset - ip400

    Hi all I have an ip400 system with 6424D+ handsets. Just added a new handset and all works ok, however when anyone tries to transfer a call by pressing the transfer button then pressing their shortcut button on the right it does not connect. If they however press the transfer button and dial...
  19. tonyvee1973

    percentages struggle

    Hi All Trying to show percentages for products within a group. In the screenshot below in the "A" section I need to see what percentage that product sales is of the total group sales. Also need to see in "B" the group percentage to all total sales. Can anyone help? Think I'm struggling at the...
  20. tonyvee1973

    divide running total by summary

    Hi All Is it possible to divide a formula by a summary? I have a running total named: @selectiononlygrandtotal I need to divide that by a summary named: sum of @curryearsum Is this possible?

Part and Inventory Search

Back
Top