Sat Mar 23, 2019 1:09 pm
Login Register Lost Password? Contact Us


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: 351
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: 351
Joined: Sat Oct 01, 2011 7:26 pm


Return to ECL

Who is online

Users browsing this forum: Bing [Bot] and 1 guest

cron