Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Have a report and one cell I need to change the the field where the gl account is in. When I change the column to where the GL account is, Excel says there is an error yet there is no error in the formula as all I am changing is the GL account.
Formula…
SI has a function for "GLActual" that nets the debits and credits.
Is it possible to add 2 different functions to get the debit and credit separately?
the data exists in the actuals currently included sub report.
I am able to open reports just fine on my computer. My boss, however, is getting #name errors on all forumulas when he runs the same reports.
The 3 add-ins are turned on in his Excel. It worked fine for him yesterday.
Any idea what the problem…
I have an Intelligence report generating and excel document. There are several sheets. One sheet in particular stops populating part of the records at line 3000. The other sheets populate just fine past the 3000 line. This sheet has 8 columns of data…
Hello
I created a union report thats uses a container in the Connector Module and this is what it looks like:
So how do i add the task pane so that i can compare these totals to the GL totals? So for example Column C would have the GL numbers anc…
hello
I am trying to filtered data so that I can get a sum. For example, I have a report that just have two columns (see diagram). I want to add up all the share codes that are "1" and get one total so that when I run the report I'll get a total amount…
I am looking for a CASE statement to replace an excel formula.
Excel formula would be: =IF(TDMMYY="0816",(N2+O2),IF(TDMMYY="0916",(N2+O2+P2),IF(TDMMYY="1016",(N2+O2+P2+Q2))))
The one I'm trying that is failing is:
CASE
WHEN "CI_UDT_ITEM_SALES_PROJ…