maintain values in dynamic selection

[cristianj23a]

Hi .

I have a table where the HA PROD EJEC is displayed by campaign and year-month.

When I do not select any campaign, the HA PROD EJEC is displayed correctly by campaign in the table.

But when I select a campaign, the HA PROD EJEC is distorted.

Please help me maintain those values when I select any campaign.

attached qvw.

Greetings.

[jwjackso]

Add the {1} in the beginning.  The first Sum() is based on the current selections.

$(=Sum( {1} Aggr(

sum( DISTINCT

{<CAMPAÑA={"$(='CAMP '&(Max(Num(Right(CAMPAÑA,4)-2))))"},COD_LOTE2-={''},CANT_REAL-={' '},BLOQ={'NULL'},DÍA=>}HECTAREA_PRODUCTIVA),VARIEDAD2,COD_LOTE2))

)

[cristianj23a]

Hi Jerry.

It's fine but when I select jul18, it shows me the null value and when I do not select it has value.

<

Thank you very much.

Greetings.

[jwjackso]

CANT_REAL does not appear to be populated for Jul 2018

$(=Sum( {1} Aggr(

sum( DISTINCT

{<CAMPAÑA={"$(='CAMP '&(Max(Num(Right(CAMPAÑA,4)))))"},COD_LOTE2-={''},CANT_REAL-={' '},BLOQ={'NULL'},DÍA=>}HECTAREA_PRODUCTIVA),VARIEDAD2,COD_LOTE2))

)

[Anil_Babu_Samineni]

May be this?

$(=Sum( {1} Aggr(

sum( DISTINCT

{<CAMPAÑA={"$(='CAMP '&(Max(Num(Right(CAMPAÑA,4)))))"},COD_LOTE2-={''},CANT_REAL-={"=Len(CANT_REAL) = 0"},BLOQ={'NULL'},DÍA=>}HECTAREA_PRODUCTIVA),VARIEDAD2,COD_LOTE2)))

[cristianj23a]

Hi Anil.

the code does not work

Greetings.