Sun Aug 07, 2022 3:23 pm
Login Register Lost Password? Contact Us

Please Note: The HPCC Systems forums are moving to Stack Overflow. We invite you to post your questions on Stack Overflow utilizing the tag hpcc-ecl (https://stackoverflow.com/search?tab=newest&q=hpcc-ecl). This legacy forum will be active and monitored during our transition to Stack Overflow but will become read only beginning September 1, 2022.



PRODUCT(GROUP,<field>) in the TABLE built-in

Comments and questions related to the Enterprise Control Language

Thu Mar 14, 2019 3:31 pm Change Time Zone

Hi,

Simple question:
There is available to the TABLE built-in
Code: Select all
SUM(GROUP,<field>)

there is no:
Code: Select all
PRODUCT(GROUP,<field>)

Any way to achieve that using TABLE cross-tab?
Yours
Allan
Allan
 
Posts: 444
Joined: Sat Oct 01, 2011 7:26 pm

Thu Mar 14, 2019 5:07 pm Change Time Zone

Salini gave me this:

Code: Select all
ROUND(EXP(SUM(GROUP,LN(dds.value))));


Its based on https://viralpatel.net/blogs/row-data-multiplication-in-oracle/
Allan
 
Posts: 444
Joined: Sat Oct 01, 2011 7:26 pm


Return to ECL

Who is online

Users browsing this forum: No registered users and 2 guests

cron