RE: [sqr-users] Formulas in Excel

[Daniel Vandenberg <vandberg@uwosh.edu>]

I think you need to change the formula in each row to get the result you want.

add 1 to #row_nbr
let $formula = '=C' || to_char(#row_nbr) || '*D' || to_char(#row_nbr)

At 08:25 AM 8/15/2005, you wrote:

>Thanks Jim. Yes, I could get the result. But my requirement is I should be 
>able to give column names when i am adding and not the values itself.
>
>I tried multiplying columns and i could get the result after the last column.
>
>let $formula = '=C2*D2'
>
>and i am writing this into a CSV file. and my CSV looks like:
>
>1  A   B   C    D   Result
>2            5   10   50
>3            3    5    50
>4            2    6    50
>
>Yes, initially the result would be 50 for all the rows. But when i 
>higlight the result column. i will get the correct result.
>
>Here my requirement is to get the correct result in the Result column when 
>user changes C or D and not when the user has to click on the Result tab 
>to recalculate the values. Is this possible?
>
>Thanks,
>Radhika
>
>>From: "James Womeldorf" <jwomeldo@fastenal.com>
>>Reply-To: "This list is for discussion about the SQR database 
>>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>>To: "This list is for discussion about the SQR database reporting 
>>languagefrom Hyperion Solutions." <sqr-users@sqrug.org>
>>Subject: RE: [sqr-users] Formulas in Excel
>>Date: Sun, 14 Aug 2005 10:46:23 -0500
>>
>>Hi again Radhika,
>>Yes you can.
>>I get the feeling my attachment was stripped from my first email, so here 
>>is the 'unattached' version :)
>>
>>Paste the following line into a text file
>>
>>1,2,= a1 + b1
>>
>>Name it x.csv.  Open it in Excel.
>>
>>(The same technique works for tab delimited files)
>>Jim
>>
>>
>>
>>-----Original Message-----
>>From: sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org
>>[mailto:sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org]On Behalf Of
>>radhika reddy
>>Sent: Saturday, August 13, 2005 5:38 PM
>>To: sqr-users@sqrug.org
>>Subject: [sqr-users] Formulas in Excel
>>
>>
>>Hi,
>>
>>   I am trying to achieve something like this for a CSV report output. Is it
>>possible to specify formulas for a CSV report?
>>
>>I can explain better with an example:
>>
>>CSV Report looks something like this:
>>
>>
>>Total Employees: 100
>>Employees Enrolled: 10
>>
>>_________________________________________
>>Instructor | Class | No. of employees | Class Name|
>>     Xyz       |   PS  |        10              |        PS     |
>>
>>This is a excel sheet. I tried my best to show how it looks like. Here, when
>>i change the number of employees it should reflect on the field Employees
>>Enrolled above. Or sometimes i need to multiply two columns. I have more
>>complicated formulas than this.
>>
>>Can I write formulas in my SQR so that when user changes the report it
>>should reflect on other fields?
>>
>>Any input would be greatly appreciated.
>>
>>Thanks.
>>
>>_________________________________________________________________
>>Express yourself instantly with MSN Messenger! Download today - it's FREE!
>>http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>>
>>
>>_______________________________________________
>>sqr-users mailing list
>>sqr-users@sqrug.org
>>http://www.sqrug.org/mailman/listinfo/sqr-users
>>
>>_______________________________________________
>>sqr-users mailing list
>>sqr-users@sqrug.org
>>http://www.sqrug.org/mailman/listinfo/sqr-users
>
>_________________________________________________________________
>Express yourself instantly with MSN Messenger! Download today - it's FREE! 
>http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users


Daniel Vandenberg
Administrative Computing
University of Wisconsin Oshkosh

Email :  vandberg@uwosh.edu 


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users