Search results for query: *

Thanks Chris, not sure how I would do that a bit beyond what little skills I have. Thanks for the reply.

I have managed to use a Derived filed with the Expression using this ISNULL(TreatNo) ? " " : TreatNo This allows me to update without any data However, I have a field available in the source file called CyNo which as the data I could do with in TreatNo. Can you use a derived field to use the...

I have a CSV file import which as a couple of issues due to the Source file not having some data One of the columns will always be Empty but the database destination does not allow Nulls A column in the Destination is not present in the CSV file and also does not allow null values So obviously...

Managed it thanks (CAST([batch end] AS float) - CAST([batch start] AS float)) * 24 * 3600 /60 - (downtime/60 + [pntr time]/60)

Hi I managed to get most sorted but I am stuck on one row of coding (CAST([batch end] AS float) - CAST([batch start] AS float)) * 24 * 3600 - (downtime + [pntr time]) AS Runtime This gives me a result of 25098.5339996806 however I need to divide this by 60 to get 418.30. I have tried to...

Hi I have a field that the results show in seconds. I want to display this in minutes and seconds but unsure how to do this. downtime AS Downtime is the filed name and the result for example on one record is 2299.35800027848 I want that to show the result 2299.35800027848 / 60 which I...

Hi I managed to get it working. I did the numbering for the Type The I did a Running Total count on only the Process which gave me the number 1,2,3,4,5 I then suppressed the Group other than 1 and 2 Long winded maybe but it worked.

I managed to get it working. I did the numbering for the Type The I did a Running Total count on only the Process which gave me the number 1,2,3,4,5 I then suppressed the Group other than 1 and 2 Long winded maybe but it worked.

Hi I have made another thread as I feel my last one as become complicated than it needs to be I have forumla that does as below for Source = 1 and Finished = 6, I want Processed to be numbered 2 to 5 (there are always just 4 processes) and then select only numbers 2 and 3 to display in my...

Another idea which may make if simple or not, I could create a forumla that does as below for Source and Finished = 6, however how do I get it it to number the Source from 2 to 5 starting in the order they list in. If {@FormattedLineType} = 'Source' then 1 If {@FormattedLineType} = 'Process'...

Well my doe worked for a short period however using Running Total field with a distinct count Product Code and on change of field set to WO Number. I have 3 types of lines Source Process Finished The source was keeping everything at number 1 in the total field, 2,3,4,5 for the process and 6...

Figured it out I believe, The spreadsheet was linked to a SQL View and the field it was using was VarChar. I did a CAST and changed it to INT. The spreadsheet is working as expected now. Thanks for the replies

Hi The column is set to General and not text as per the video. So the options are not available to convert when I highlight the column in anyway. Thanks

Hi Thanks for the reply, I have actually tried changing the formant of the column to number instead of general, even tried text but I am getting the same result each time unfortunately

Hi I have a Pivot table which as a filed for the rows called ProdGroup. It as numbers from 1 to 12 and I have managed to do the totals and subtotals on each group. However the numbers for the columns are out of number order, so instead of going from 1 to 12 it is putting the 1's first so I...

Hi I have a long list of dates in 2 columns and want to calculate the days between them but exclude weekends and bank holidays. I have used =NETWORKDAYS(F2,G2,P2:P10) The P2:P10 have the bank holiday dates in but when I copy the formula down it changes for example =NETWORKDAYS(F3,G3,P3:P11)...

Thanks for the reply I ended up with this code with No Suppress If {#Row No} <> 1 and {#Row No} <> 2 and {#Row No} <> 3 AND {@FormattedLineType} = 'Process' THEN True Thanks

Sorry my issue as changed since the first post. I managed to add in distinct row numbers which worked. However I now need to include a Line type which is named Source, Process and Finished. I need to show the rows with Line Type Source and Finished and only the first 2 rows of Process in one...

Hi I have a report that is grouped by orderlines. The orders may have up to 6 rows or mote. However, I want to create 2 sperate reports. One report that only shows the first 2 rows of the orderlines and hide the rest The other report to only show the 3rd and fourth row of the orederlines and...

Hi Its ok managed it I used =TEXTSPLIT(A2,";") Thanks