Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a variable that works out an average for me, i am using this in a straight table with a product dimension then i have the totals summed up giving me a total of all the averages. (Top table below)
Does anyone know how i can use the variable in a text box but displaying the total instead
this is my variable
$(vTargetAvg_Listings)
=
avg({$<
[it_target_type]={"Listings"},
[ld_Dist]={"4"},
[ld_Outlet_Check_Date]={">=$(=Timestamp(FirstDayCurrentFiscalYear))"}
>}
[it_target_value]
)
You'll probably need to use advanced aggregation, i.e. the aggr() function, maybe like this:
=sum(
aggr(
avg({$<
[it_target_type]={"Listings"},
[ld_Dist]={"4"},
[ld_Outlet_Check_Date]={">=$(=Timestamp(FirstDayCurrentFiscalYear))"}
>}
[it_target_value]
)
,Brand )
)
You'll probably need to use advanced aggregation, i.e. the aggr() function, maybe like this:
=sum(
aggr(
avg({$<
[it_target_type]={"Listings"},
[ld_Dist]={"4"},
[ld_Outlet_Check_Date]={">=$(=Timestamp(FirstDayCurrentFiscalYear))"}
>}
[it_target_value]
)
,Brand )
)
Great, thanks for the answer