Bypassing field is not working in nested aggr expression

aatish12345 — Fri, 15 Nov 2024 21:40:59 GMT

Hi All,

I have an expression in below format

if(aggr( max(
if(aggr( max(
if(aggr( max(date(ReleaseDate)), Region) = [ReleaseDate],

[MovieNumber])), Region) = [MovieNumber],

date(BreakEvenDate))),
Region, [MovieNumber],[MovieName])=BreakEvenDate,

MovieCollection)

Here I wanted to bypass Continents Field. So that the selection of Continent wont affect the result. But When I used it as shown below, it still changing the data based on Continent selection:

if(aggr({<Continent=>} max( {<Continent=>}
if(aggr({<Continent=>} max( {<Continent=>}
if(aggr({<Continent=>} max({<Continent=>}
date(ReleaseDate)), Region) = [ReleaseDate],

[MovieNumber])), Region) = [MovieNumber],

date(BreakEvenDate))),
Region, [MovieNumber],[MovieName])=BreakEvenDate,

MovieCollection)

Then I used Only() Function on the top of the above expression, then bypassing was working as expected but the final result of MovieCollection data was getting changed.

I want to know whether it is possible to bypass Continent field using some other way apart from Only() function

Regards,
Aatish

topic Bypassing field is not working in nested aggr expression in App Development

Bypassing field is not working in nested aggr expression