Search results for query: *

I want to highlight all duplicates based on the first text of each cell in a column. There are many but this based on any duplicate first text word in the column not just a specific text. E$5:E$132

I have a table that has many rows with one of the columns which has an non-calculated percentage. I want to create a pie chart with this column as an axis. How do I do this? See attached example. thanks for your...

Hello, I want to copy a worksheet from a workbook into another workbook but keep part of the formula. Delete the .xlsx file but keep the Bill Jones K15 portion ='[Total Commissions_Revenue Feb 2023 (Executive Only).xlsx]Bill Jones'!H15 Thanks for your assistance.

I have raw data which has the same address for two or more customer numbers. I need to show one customer number in one column and the the other customer number(s) in an adjacent column with a summary of Amt by Department. I have tried to utlize pivot table but unable to get the information the...

I have this formula in a report which I need a Grand Total DistinctCount ({AR_Customer.CustomerNo}, {AR_Customer.SalespersonNo}) - {#CustomerCountNoYTDSales} (this last part is a running total formula: Sum ({@YTD}, {AR_Customer.CustomerNo})=0 What I am trying to get is a Grand Total of Distinct...

I need a formula that represents the folowing: If b2=c2 and R2>0 then R2 else 0 Could use the help today if possible. Thanks very much!

My date formula for only viewing specific dates exports to Excel as 1/0/1900. What can I do to get a blank date in Excel? (blank dates viewed in Crystal exporting as 1/0/1900) My formula: if {AR_InvoiceHistoryDetail.UDF_CC_CODE}= "Rent" then {SO_SalesOrderHeader.OrderDate} Thanks very much.

I have a formula that is giving me True or False. I need the intended Value not True or False. Appreciate your assistance. If GroupName ({vActivityRpt.SalespersonNo})="xyz" then {vActivityRpt.SalesManagerName}= "John Doe" OR if GroupName ({vActivityRpt.SalespersonNo})="abc" then...

If a field is null, I want to replace it with "In Transit" else the field. I have tried various syntax to no avail. The "In Transit" does not appear in the report for blank warehouse city. I have Default Values For Nulls selected Formula below: if isnull({IM_Warehouse.WarehouseCity})then "In...

Trying to get Select Expert Group formula for only invoices that have an amount >= 15000.00 OR >= -15000.00 (negative number) This is the first part of my formula: {AR_InvoiceHistoryDetail.ExtensionAmt} >= 15000.00 (My group is on AR_InvoiceHistoryDetail.InvoiceNo) Appreciate your assistance...

I have inserted a group by invoice date and "the section will be printed:" "for each month". However, It is printing the month every time a date changes to another day. within the same month. I need the group to group all details for the same month. i.e. Jan will show the detail section for...

Below is my formula but it is not working. Please assist with correct formula or let me know how to attain this in my report: 1. I want the Item Code if it is "/Delivery" and the Extension Amt - I don't want the item code nor the extension amount if the item code is not "/DELIVERY" I do want...

Need Average Sale Amount of each customer by Salesperson: This is my YYD Summary for each salesperson if {AR_CustomerSalesHistory.FiscalYear} = {?Fiscal Year} and {AR_CustomerSalesHistory.FiscalPeriod} in {?Fiscal Period} then {AR_CustomerSalesHistory.DollarsSold} else 0 This is number of...

I am just a beginner with SQL. I have two queries which were previously set up. The first formats dollars and cents, however the second one does not. I want to know if I can insert the Convert statement into the second query in the appropriate place? Correct value for money in one query: select...

If two rows of data has duplicate data with the exception of the {extended amount} but the two rows with extended amount sum to zero. How do I suppress both rows? I do not want any grouping. i.e. row 1 field {customer no}, field [ {item code}, field [invoice no},field {extended amount} = +5.00...

A new request for a formula: Revenue: 125,206.00 Commission Amt:_________ Tier Range Commission Rate 0-124,204.99 1.75% 124,205-144,204.99 2.25% 164,205 -184204.99 2.5% 184205-999,999 3.0%...

I have a formula which is like the following: (I54-'AJF Amos'!I50-'ARF Aaron'!I50-'BNB Brittany'!I50)*M34 Each month I want to change the I (or whatever column it is on) to the next column (i,e. J) without having to go into the formula each month. Will not change the row. Any suggestions...

Need a formula to bump commission according to the attached sheet. Your assistance is greatly appreciated.https://files.engineering.com/getfile.aspx?folder=bae4e68f-2fbb-4c25-a210-8bf06323618d&file=Formula_Needed.xlsx

I have a cross tab report where {AR_InvoiceHistoryHeader.CustomerNo}+" "+{AR_Customer.CustomerName}+ " "+{AR_InvoiceHistoryHeader.ShipToCity}+{AR_InvoiceHistoryHeader.ShipToState}+" - "+{AR_Customer.SalespersonNo} is my main row. I want to subtotal all columns (which is the summary of...

I would like to have two columns in my report. One with sum of field for current date range (a parameter) {?Invoice Date Range}(summary is based on ARhistoryextension (field) within grouping-which is in place already ). I need a column with sum of field for current date range minus 1 year also...