Search results for query: *

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

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...

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)

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...

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...

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 :)

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.

sorry Skip, what do I do with that?

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...

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!

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...

Ah ok, thanks all

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...

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...

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.

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?

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...

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...

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...

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?