|
|
Browse by Tags
- ' as decimal separator (for SharePoint)
- >=
- 2
- 2007
- access
- Access form
- and match
- another
- array
- as400
- attribute
- auto
- average
- avg
- based
- between
- bug
- bug rates
- calculate
- calculated
- cast
- cell
- change
- coldfusion
- color
- column
- condition
- conditional
- convert
- converting
- count
- crm
- crystal
- Crystal Reports
- cummulative
- cumulative
- current
- data
- date
- dates
- db2
- decimals
- detail
- different
- distinct
- error
- excel
- Excel VBA
- field
- fields
- Filter
- font
- footer
- form
- formula
- formulas
- formulas - question
- function
- functions
- get
- grand
- group
- group summation
- groups
- HAVING
- hhmmss
- Hidden Rows
- how
- i
- iff
- join
- limit
- max
- multiple
- mysql
- negative
- numbers
- oracle
- procedure
- query
- range
- report
- reporting
- reports
- running
- script
- select
- services
- SHELL
- sql
- subform
- syntax
- table
- time
- total
- two
- update
- using
- vba
- XSLT
-
MySQL sum of two fields multiplied
i want to compute the total $ for records (rows) in a table where each row has a quantity and a (different) unit price. thus if the table contains: (qty) (unit price) 1 10 2 100 3 1000 i want the answer = 3210 how can i do this without a while loop to multiply individually and accumulate with a running... -
xslt + NaN
Hi, I am trying to sum up a value using a published algorithm. The algoritm seems to get the correct value, but I cannot seem to format the value without getting NaN. Could anyone help. Here is the XML. And here is the xslt. xmlns:xsl=" http://www.w3.org/1999/XSL/Transform " xmlns:msxsl="urn... -
sum a range VBA
What is the syntax to sum a range? For example Sum Worksheets("test").Range("A1:D1") -
Problem summing decimal numbers with ',' as decimal separator (for SharePoint)
Got the XSLT and data that are attached here - trying to calculate the sum of decimal numbers (note it should be able to handle empty values but is not right now). Problem is that the current solution only returns the first value, not the sum (in this case 2 and -2) Any idea as how to make this work... -
latex - sum in Lyx
Hello, I'm trying to write a sum (with indexes) in Lyx. Normally I would write the command \sum_{i=1}^{n} but this doesn't work in Lyx, the part "i=1" isn't underneath the sum symbol and when I write "^" it jumps into the uperscript of "i=1" thanks -
CHANGE NULL TO ZERO WHEN SUM IN SQL ( MYsql)
The code below when , SUM(`sellnote`.Paid) then `sellhead`.RcvAmt + SUM(`sellnote`.Paid) As total become null How can I change the code SUM(`sellnote`.Paid) if it is null it choose be come 0 SELECT `sellhead`.Code , `sellhead`.CName , `sellhead`.NetAmt , `sellhead`.RcvAmt , `sellhead`.UDT , `sellhead... -
Crystal Reports: Sum of Summary Fields (Invoices + Open Orders)
Hello Experts, I am somewhat new to Crystal Reports. I am using version 8.5, standard. I need to create a report that lists the total sales by customer (invoiced orders + open orders) for the year so far, in descending order based on the total. So the report will look something like this: AcctNo CustName... -
How do I use the correct sum function in crystal report formula editor
I have three fields I developed with formula editor name #countd ,#countd2, and #countd3 how do I use the sum() function to add a field in my report to display the total. -
Summary of a formula field not allowed
I know there are a lot of similar questions, but I can't seem to understand how to solve my specific problem. I'm trying to make a Running Total or other summary of the following field in my group footer... if isnull({CompletedHours}) then 0 else if {RequiredHours}>={CompletedHours} then ... -
Sum Visible Columns or Rows in Range
I came across this user defined fuction on this site. I would like to perhaps modify the below function to work like the SUM function. For example, if my formula says =Sumvisible(E2, F2, H2, L2), it would add those cells that are visible. If I hide Column F, then my formula should recalculate with E2...