Agg function

New-here1 — Thu, 01 May 2025 11:53:51 GMT

Hi,

Using the below, I get the correct result in the column, in the pivot table however, it is only showing the result in one column rather than all the columns. If this can be done then please help as I am a little stuck.

Thank you

if(GetSelectedCount(Date)>0 and fabs(Num(Sum({<Date={"$(=max(Date))"}>}mydata),'#,##0.00000000')
- Num(Sum({<Date={"$(=min(Date))"}>}mydata),'#,##0.00000000'))>=5.00,
Aggr(Num(Sum({<Date={"$(=max(Date))"}>}mydata),'#,##0.00000000')
- Num(Sum({<Date={"$(=min(Date))"}>}mydata),'#,##0.00000000',0.001), [Name], [Type], Owner), null())

Re: Agg function

rwunderlich — Thu, 01 May 2025 21:25:02 GMT

Aggr is by default DISTINCT. Try adding the NODISTINCT keyword to your Aggr

Aggr(NODISTINCT...

-Rob

topic Agg function in App Development

Agg function

Re: Agg function