Expression Subtotal

manojkulkarni — Thu, 23 Dec 2021 15:31:55 GMT

Hi All,

I am using below expression in one of the measures in pivot table, it is working fine in line entires but where as in subtotal it is not working properly. When we make selection of particular Dimension in the chart it work's fine. Any suggestions or advise on the below expression to work in any conditions.

( EXP(sum(Aggr(Log(1+Sum({$<CDate={">=$(=date(min(CDate)))<=$(=date(max(CDate)))"}>}Nr) /
FABS(Sum({$<CDate={">=$(=date(min(CDate)))<=$(=date(max(CDate)))"}>} Dr))),CDate)))-1 )

Thanks in advance

Re: Expression Subtotal

rubenmarin — Sat, 25 Dec 2021 09:23:39 GMT

Hi, have you tried adding the other dimensions to the aggr?:

( EXP(sum(Aggr(Log(1+Sum({$<CDate={">=$(=date(min(CDate)))<=$(=date(max(CDate)))"}>}Nr) /
FABS(Sum({$<CDate={">=$(=date(min(CDate)))<=$(=date(max(CDate)))"}>} Dr))),CDate,[Dimension2],[Dimension3]...)))-1 )

topic Expression Subtotal in App Development

Expression Subtotal

Re: Expression Subtotal