Error: Nested Aggregation not allowed

[brunolelli87]

Hello guys,

I'm using the following expression on a table chart to collect the Growth Rate, and it's working perfectly:

=rate(3,0,-Avg({<Flag = {'3 Year Ago'}>} LOPP/IGPD)* FirstSortedValue(TOTAL IGPD, -DVPG, 1),Avg({<Flag = {'Current'}>} LOPP/IGPD)* FirstSortedValue(TOTAL IGPD, -DVPG, 1))

My Table chart has the following dimension:

=if(Date(AsOfDVPG)>today(),'',Date(AsOfDVPG))

I'm trying to show the last available Growth Rate, when the user select a specific field. For that I'm trying to use the following expression:

= FirstSortedValue(
rate(3,0,-Avg({<Flag = {'3 Year Ago'}>} LOPP/IGPD)* FirstSortedValue(TOTAL IGPD, -DVPG, 1),Avg({<Flag = {'Current'}>} LOPP/IGPD)* FirstSortedValue(TOTAL IGPD, -DVPG, 1))
-DVPG, 1)

But I'm getting an error: "Error: Error in Expression: Nested aggregation not allowed"

How can I do that?

How can I show the last available Growth Rate on a FieldBox?
In this example, I'm expecting to see the 1.25%.

Thanks

[brunolelli87]

Hello folks,

Do you guys have any idea about how can I solve it?

Thanks

[brunolelli87]

Any idea guys?