Fixed expression with Aggr function

umuto — Tue, 28 Jul 2020 13:18:54 GMT

Hi all,

We try to create a fixed expression via using aggr. function. But when we use aggr. function we can not fix the result, according to Variant Region selection result is changing which we want to fix.

The expression:

Count({<[Region]={'RTC'}>}distinct
Aggr({<[Region]={'RTC'}>}
if( (Min({<[Region]={'RTC'}>}[StartSales])<= 3 and Max({<[Region]={'RTC'}>}"EndSales") >= 1 ),Material)
,Material,[Report Period],[Region])
)

Also you can find qvf file attached

topic Fixed expression with Aggr function in App Development

Fixed expression with Aggr function