http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 02 May 2026 00:12:06 +0000 Mon, 31 Aug 2015 04:50:10 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=22692 http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ http://forum.codejock.com/forum_posts.asp?TID=22692&PID=73839&title=in-row-calculation#73839 Author: skiman
Subject: 22692
Posted: 31 August 2015 at 4:50am

With sumsub I can make subtotals on the grouprow, but I need a multiplication on a row.

In fact, I want to have a formula for a record:item.

I would like to have the possibility to add columns, and to define the formula for that column. I would add the item for each row, and to insert the value in that item. A value which is calculated according to a new formula.

The item has the formula property, so I would expect it can be used?
]]> Mon, 31 Aug 2015 04:50:10 +0000 http://forum.codejock.com/forum_posts.asp?TID=22692&PID=73839&title=in-row-calculation#73839 http://forum.codejock.com/forum_posts.asp?TID=22692&PID=73819&title=in-row-calculation#73819 Author: skiman
Subject: 22692
Posted: 28 August 2015 at 7:16am

Hi,

I don't want to make a SUM, but I want to multiply two columns. I was expecting that C3*C4 would give me the result.

If C3 = 5 and C4 = 20 then C3*C4 would be 100.

With sumsub I can make subtotals on the grouprow, but I need a multiplication on a row.
]]> Fri, 28 Aug 2015 07:16:19 +0000 http://forum.codejock.com/forum_posts.asp?TID=22692&PID=73819&title=in-row-calculation#73819 http://forum.codejock.com/forum_posts.asp?TID=22692&PID=73818&title=in-row-calculation#73818 Author: olebed
Subject: 22692
Posted: 28 August 2015 at 6:58am

Hello Chris,

Pattern for property "formula" is
SUMSUB(R#C#:R#C#) or SUM(R#C#:R#C#) 

R is row index and C is column index and  * instead of # - means all rows or columns

see "Formula Property" in documentation
C:\Program Files (x86)\Codejock Software\ActiveX\Xtreme SuitePro ActiveX v16.4.0\Help\SymbolReference.chm

So on setting caption: If formula is correct  then caption of ReportRecordItem  replaced with result  else caption text used. So to update text of item with formula you need to set any caption even empty string.

Regards,
 Oleksandr Lebed ]]> Fri, 28 Aug 2015 06:58:37 +0000 http://forum.codejock.com/forum_posts.asp?TID=22692&PID=73818&title=in-row-calculation#73818 http://forum.codejock.com/forum_posts.asp?TID=22692&PID=73755&title=in-row-calculation#73755 Author: skiman
Subject: 22692
Posted: 21 August 2015 at 4:57am

Hi,

I'm trying to use some in row calculation.

I have three columns:
Description, Quantity, Unit price.

I want to add another column: 'Total', And I added an extra item to each record.
oItem := oRecord:AddItem("")
oItem:format := "%.2f"
oItem:formula := "C1*C2"
oItem:caption := "x"

I expected/hoped that the result of this item would be shown in my new column. In my column the 'x' is shown?

Another way would be to have a formula for a Column. I was thinking of using the TAG property to put my formula in.

Any suggestions for this?

]]> Fri, 21 Aug 2015 04:57:14 +0000 http://forum.codejock.com/forum_posts.asp?TID=22692&PID=73755&title=in-row-calculation#73755