can you not add calculated fields in SmartList?

Hello:

Can you not add calculated fields togather in SmartList?

childofthe1980s
0
7/30/2008 2:51:01 PM
greatplains 29623 articles. 6 followers. Follow

2 Replies
562 Views

Similar Articles

[PageSpeed] 41

I don't know for sure, but I seem to have a vague recollection of having a 
problem with that, too.

Can you get around it by doing something like so:

A = some field * .5
B = another field * 1.5
C = A + B (but this doesn't work)

Instead of C being calculated as A + B, could you make C = (some field * .5) 
+ (another field * 1.5)?



-- 
Bud Cool
Microsoft Certified Business Management Solutions Specialist, GP 9.0 
Financials
Currently supporting: GP 9.0, SP2


"childofthe1980s" wrote:

> Hello:
> 
> Can you not add calculated fields togather in SmartList?
> 
> childofthe1980s
0
Bud (544)
7/30/2008 3:42:02 PM
You can bypass your C = A + B limitation by building a view in SQL Server and 
exposing it to SLB. The issue seems to happen when you have any combination 
of 'some field' with 'another field' regardless of the expression.

Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com


"Bud" wrote:

> I don't know for sure, but I seem to have a vague recollection of having a 
> problem with that, too.
> 
> Can you get around it by doing something like so:
> 
> A = some field * .5
> B = another field * 1.5
> C = A + B (but this doesn't work)
> 
> Instead of C being calculated as A + B, could you make C = (some field * .5) 
> + (another field * 1.5)?
> 
> 
> 
> -- 
> Bud Cool
> Microsoft Certified Business Management Solutions Specialist, GP 9.0 
> Financials
> Currently supporting: GP 9.0, SP2
> 
> 
> "childofthe1980s" wrote:
> 
> > Hello:
> > 
> > Can you not add calculated fields togather in SmartList?
> > 
> > childofthe1980s
0
MarianoGomez (3440)
7/30/2008 4:05:02 PM
Reply:

Similar Artilces:

how can I fix the size of frame? once I fixed ,the user cannot changed its size
handle WM_GETMINMAXINFO see http://www.codeguru.com/forum/showthread.php?t=318933 "msnews.microsoft.com" <on_lixing@163.com> д���ʼ� news:OgxZDM45FHA.472@TK2MSFTNGP15.phx.gbl... > > Handle CFrameWnd::OnGetMinMaxInfo and specify whatever size you want for your frame to be. -- Ajay Kalra [MVP - VC++] ajaykalra@yahoo.com "msnews.microsoft.com" <on_lixing@163.com> wrote in message news:OgxZDM45FHA.472@TK2MSFTNGP15.phx.gbl... > > ...

Can I mouse over an object and make it move?
I'm going to have a survey question on a slide where the answer is a number. I'm going to have small icons with the numbers on them (0, 1, 2, 3, 4, 5+). I only want the icon with the number 3 on it to be "clickable" and send them to the next slide. The other icons I want to move to another spot on the page if they mouse over the icon. Is this possible? How do I do this? Thanks in advance for any help! In article <AA0384FC-8446-44EC-8509-C71324B4F2A1@microsoft.com>, Sharpie wrote: > I'm going to have a survey question on a slide where the answer is a ...

can not send without error code
Hi, kindly help me. Out of sudden I can not send my email, but I still can receive email. My outgoing email just sitting in the outbox. I try send and receive several times, there is no error code but they only receiving without even try to send I do not change anything in the setting and even truy to recheck all the setting (SMTP, etc) and everything still ok need your immediate response, many thanks in advance How to Remove a Stuck Undeletable Message in Windows Mail http://www.vistax64.com/tutorials/62560-windows-mail-problems.html WMUtil http://www.oehelp.com/WMUtil/De...

Calculate As of Date Check Book Opening Balance
Hi Is there any way to calculate as of opening and closing balance of a given check for Payments and Deposits Listing report Module = Banak Management Regards Irfan ...

Calculation time
I have a large file, approx 10MB, in excel 2003. Most of the data relates to calculations for around 5,000 records, and the workbook takes too long to recalculate. All the vlookup's have been replaced with Index / Match, but it's still slow, and I have a number of macros that rely upon it recalculating. Based on a post here, I went to this site: http://msdn.microsoft.com/en-us/library/aa730921.aspx and ran the timer macros to try and isolate the problem. The FullCalcTimer takes around 19 secs The ReCalcTimer takes 0.00013 secs, and The SheetTimer takes no more than 0.01...

How to create a CLR DLL for Sql Server 2005? Is it just any .net class library that you can load into Sql Server 2005 or is there some special project type that I need to start with?
How to create a CLR DLL for Sql Server 2005? Is it just any .net class library that you can load into Sql Server 2005 or is there some special project type that I need to start with? "DR" <softwareengineer98037@yahoo.com> wrote in message news:uJRyKcbFIHA.3980@TK2MSFTNGP03.phx.gbl... > How to create a CLR DLL for Sql Server 2005? Is it just any .net class > library that you can load into Sql Server 2005 or is there some special > project type that I need to start with? > You can do it all "by hand" but there is a template "SQL Server project&...

Insert fields dynamically into database from a staging table
Hi all, In our lab when ever a test is performed results are stored in test_results table ( 10 records at maximum) and with click of a button these results should be loaded to database, but I have any issue here, each time the test_result table will have different field names ( one time it will have test1 , test2 , test3 with labid, next time it might have test1, test4, test5 and labid) so how can I load these fields from test_results table into database auomatically. Datebase has all these fields so how can I map the test_results tables fields to database fields to run my dynamic inse...

Add PA Inventory Transfers to eConnect
We have on client in particular that are trying to implement an integration that will ultimately create many PA Inventory Transfers. They would like to use eConnect to do that, however, only standard Inventory Transfers are available. One of two things could happen, PA Inventory Transfers can be merged into the standard Inventory transfers much the same as the PO's were, or create the eConnect schema for the PA Inventory Transfers. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion,...

Can't get rid of mailbox??
I have a user that was disabled, then removed from the domain, but I can't get rid of this _DIS <username> from showing in the Mailbox Resources screen. Any ideas? Thanks!! Do you have mailbox retention set up (30 days by default)? Is the mailbox showing up in Mailbox Resources with a Red 'X' on it? Is it if you run the clean up agent? If it is showing up with the red 'X' and you have mailbox retention set that is why it is still there. You can manually purge it by right clicking on it in Mailbox Resources and choosing 'Purge.' -- Hope that hel...

In RMS PO add Level Pricing A, B or C for customization
Hi, Currently we are not able to add level price A, B or C in the PO template. If there is a need to be able to use any of the item level pricing it should be made available for customization purposes. Thanks, Mihir Shah Diviasoft, Inc. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in...

Add Movie to Outlook E-Mail Message via "Web Tools" toolbar--question
Using Outlook 2003 (in fact all of Microsoft Office 2003), and have Word selected as e-mail editor. Windows XP Pro with all updates. Recently I discovered on the Office web site a way to insert a movie (inline) to an e-mail message. I have one question about its implementation. If (in an HTML-formatted e-mail, and Word selected as e-mail editor) with the cursor in the body of the message, you click on "View", "Toolbars", you can select a toolbar called "Web Tools". On that is an icon that says "Movie". If you click on it you can add a movie to the e-ma...

How can I split a project day into hours to avoid overallocation?
Hello all, I am still facing overallocation problems. I have looked at other posts (including Jan's); but, I am having trouble resolving the over allocation. For example: It seems to me that - if two tasks happen on the same day (even if they are both 2 hours long and the working day is set to 8 hours) MS Project makes them clash. How can I say - set one task to start at 9-11am and one to start at 1-3pm? Surely this will avoind the overallocation. Why doesn't MS Project seem to realsie that: if the working day is 8 hours and someone is working 100% on a 4 ...

Newly created users can not log in to Exch2K
I'm running Win2K Server sp4 and Exch2K sp3. As of last Friday, any newly created user can log into the domain but can not access the exchange server. They keep getting the "user-ID, domain, password" prompt. I've tried deleting the user and re-adding to no avail. I've checked licensing and all is well in that area. Any ideas? Thanks in Advance. Hi, Did you checked the user's properties and can you see the users e-mail address ? I think that the user properties are not updated. Do a manual update to all, close ESM and open again and see. And check is the admi...

can't get sheet to display after editing header
I was working on a spreadsheet in Excel 2007 that I had previously created in Excel 2003. When I edited the header in page layout and switch back to normal view my data disappeared. I can see the data in print preview, but don't know how to view it and work with it in normal view because in noraml view it is hidden. What am i doing wrong? Jas ...

Can't delete "virus" program from Temp Folders
Hi! I have 3 remaining "virus" programs in temp folders: * c:\windows|temp * c:\Doc & Sett\name\local settings\Temp When delete or move to desktop, get error: "Cannnot move........being used by another program..." Tried Safe Mode, but "virus" programs not there...... Any way I can delete or move to trash? MUCH THANKS! Gene:) What program are you using to try to remove them? What anti-virus app is installed, and is that what you are using to remove them? Install update and run Malwarebytes Anti-Malware and see if it can remove them in...

Can't view template file in Tools>Options>File Locations
I have created a template and saved it to a shared folder. When users who have access to this folder try to add this template to their 'On my computer...' template list by selecting Tools>Options>File Locations>Workgroup templates>Modify, the template is not visible in the 'Modify Location' window. The template is visible in Windows Explorer, and when users navigate to its location in Word using File>New. Why would the template not appear in the 'Modify Location' window? Any ideas for how I can make it appear? In that dialog, you will no...

Can't Delet Email Message
I have an email in my Outlook 2002 inbox (a forwarded task) that I cannot delete. When I try to delete it I get an error message saying "Outlook cannot do that action on this type of attachment." I experienced a similar problem in Outlook Express when my inbox was corrupted and fixed that problem by deleting my inbox. But when I try to do something similar in Outlook 2002 I just get an error message that says the .pst file is in use. Any suggestions? Try closing Outlook, moving the .pst to another location and then import everything back in filtering out the bad message if ...

Can't access send/receive under mail setup
I am using Outlook 2003 with exchange. I want to add a pop3 account. The Pop3 account sends but won't receive (although the Outlook test message is fine). When I go to tools/options/mail setup and push the send/receive button, nothing happens. I have just installed a new hard drive. This worked on the old one, and on other computers. I have recreated the profile from scratch but I have the same problem. What's going on? Can someone help me? -- Thanks. Sammie SBS 2003, OFFICE 2003, XP-PRO-SP3, IE7 ...

Auto Fill Fields
I have a database of contacts (names, addresses, phone numbers, emails). I have created a table with this info already filled out (imported from Excel). All I want to do is create a form with a single drop-down list where, when the last name is selected, all the other fields automatically populate with that person's correct information. I have tried DLookup but that seems too cumbersome and doesn't work unless I go to design view and back to form view. Is there not a simple function in Access that lets me do what I need to without having to write code. I am NOT a code writer,...

how can i copy a document to a CD without making it read only?
HOW CAN I COPY A DOCUMENT TO A CD WITHOUT MAKING IN READ ONLY? You can't. It is not the file, but the media, that is read only. Even CD-RW media does not allow editing a file on the CD. Copy te file from CD to HD, mak edits and if a CD-RW you should be able to burn the edited file back to the CD. hth "DON" wrote: > HOW CAN I COPY A DOCUMENT TO A CD WITHOUT MAKING IN READ ONLY? ...

calculation mode
hi all, i build some macro in excel based on access, at the start i'm doing manual calculate in the code so it will not desturn the proccessing but in the end of my automation i'm bringing back the automatecalculation but then the proccessing is taking alot of time even more then the accually vba proccessing, how can i faster this issue? I don't know a way of getting excel to speed up calculations--except for getting a faster pc. And here are a couple of sites that discuss slow performance. The first is by Charles Williams and the second by David McRitchie: http://www.decision...

Can't start Money2004
Just installed Money 2004 and when I click on the icon to start Money it pops up a window and said "Money has encountered some problem" and have to close. Is that because of antivirus program. I have already disabled Norton Antivirus. How can I get Money to start??? I encountered exactly the same problem installing money 2004 on my winxp... :( The only thing i could do is... downgrade it back to 2003.. >-----Original Message----- >Just installed Money 2004 and when I click on the icon to >start Money it pops up a window and said "Money has >encountered so...

Exchange 2003 can send, but not receive any messages
Hi there! We've got an issue with our SBS 2003 box and would appreciate any help to solve it; all messages are sent okay - to the domain and to the Internet - but no Internet messages are received. Exchange 2003 is running behind the "basic firewall" of SBS 2003 with an ADSL line, and the MX record seems to be correctly pointing to it: Domain is "pleni.com.br", Public and static IP address is 200.204.179.15. The SMTP Virtual Server is assigned to all IP addresses on the server (the public one listed above, and the internal 192.168.16.2). It's granting relay ...

can 2 copies of mail be saved in outlook
I would like to be able to have 2 copies of mail saved in Outlook, so mail can be simultaniously be opened on 2 computers with the same email address. Is this possible? Outlook saves data on the local PC If you want to access the same recieved mails on another PC, you set up your mail account in Outlook on the other PC, and on both Outlooks you select the option to keep a copy on the server. (The sent mail will only be seen on the PC it was sent from) If you use an imap account the mail will be in sync on both PC's "dd" <dd@discussions.microsoft.com> wrote ...

How do I add GAL to "Reguarding " in CRM?
Hi all My customer want to add GAL to "Reguarding" in CRM. How do I do that? Should I do somthing to onChange() event? thank you for your time. Yifei ...