Item8410: CALC + another Macro within a SEARCH

Dear All,

I would like to pick up a value from column 2; convert it in some way and print the sum below the search. To do so, I experimented with nested Macros (CONVERTCUR, CALC) within a SEARCH and CALC to produce a summary. Below is a summary of what I tried. It still does not work, but I feel that a table like would help users a lot to what works and what does not.

| *Topic* | *C2* | *C3* |  *C4* |  *C5* | *C6* |
%SEARCH{
nonoise="on"
"amount"
format="| $web.$topic | 100 | \
$percntCONVERTCUR{amount=$quot100$quot from=$quotUSD$quot to=$quotEUR$quot }$percnt | \
$percntCALC{ $percntCONVERTCUR{amount=$quot$dollarT(R$ROW():C2)$quot from=$quotUSD$quot to=$quotEUR$quot }$percnt }$percnt | \
$percntCALC{ %$NOP()CONVERTCUR{amount=$quot$dollarT(R$ROW():C2)$quot from=$quotUSD$quot to=$quotEUR$quot }$NOP()% }$percnt | \
$percntCONVERTCUR{amount=$quot$percntCALC{$dollarT(R$ROW():C2)}$percnt$quot from=$quotUSD$quot to=$quotEUR$quot }$percnt |" \
}%
| TOTAL | %CALC{$SUM($ABOVE())}% | %CALC{$SUM($ABOVE())}% |  %CALC{$SUM($ABOVE())}% | %CALC{$SUM($ABOVE())}% | %CALC{$SUM($ABOVE())}% |

I would have liked to post something that works right here, but I couldn't find a macro to replace my CONVERTCUR. Please let me know which MACRO would be appropriate and I will ammend this task.

For me the results are

Topic             C2     C3                      C4      C5                      C6
TestTopic1    100    70.761392584206    0    70.761392584206    70.761392584206
TestTopic2    100    70.761392584206    0    70.761392584206    70.761392584206
TOTAL            200    141.52                  0       0                       200 

• C2 is fine
• C3 is fine, but not quite what I wanted
• C4 does not work because CALC finds the }% (or something like that) -- Maybe somebody could comment
• C5 fields are fine, but sum is broken. From the spreadsheet log I could see that the total-SUM sees CONVERTCUR, but not the value. However, the values are substituted later -- Maybe somebody could comment
• C6 sorry - this is weird

It would great if somebody could post a solution OR suggest an alternative route to make this less painful while retaining some flexibility.

Best Regards,

Henrik

-- HenrikRusche - 22 Jan 2010

This should have been asked in Support web; it's not a task.

Closing no-action.

-- CrawfordCurrie - 21 Jul 2010

Commenting is disabled while not logged in