Skip to main content

PRODUCT rollup function

  • September 26, 2026
  • 0 replies
  • 8 views

Alexey_Gusev
Forum|alt.badge.img+25

Hi,

Just a small lifehack - how to get PRODUCT function with Rollup field,
using LN(A*B*C)=LnA+LnB+LnC, and SUM( ) as aggregate function
You need to add LOG(Number, EXP(1)) field in Source table and EXP(Sum) in result 
You can use base 10 as well, LOG(Number), and POWER(10,Sum) with the same result