Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please, how can I do that?
I have fields date, month, year and quantity and wanna show in a dinamic table the sum of the quantities of the month and year selected, disregarding the day that is selected.
So I will be the sum of the day and the sum of the month.
Thank You in advance
Hi,
If you have 3 fields: Year, Month and Day and you want to show the sum of quantities but only for the month and year selected you need: Sum({<Day=>} Quantity)
Gabriel
Hi,
If you have 3 fields: Year, Month and Day and you want to show the sum of quantities but only for the month and year selected you need: Sum({<Day=>} Quantity)
Gabriel
Thank You
hi
how to find 3 year of data using the set analyst
try
sum({<year={">$(=max(year)-3) <=$(=max(year))"}>}value)
hi
friend's
I have year 2003,2004,2005,2006,2007
then how to get max(year), min(year) hear i get max(year) from ctrl+alt+v Vmax=max(year) but not get Vmin=min(year)
Find this only from frant end ctrl+alt+v
Reply fast
didn't got your issue,
try to rename the field Year like Year_t for testing..
And then see the issue.. or else upload your application or screenshot
i think question is to get last three years of data in chat ?
do this
declare variables For Eg: VmaxD=max(Year)
VminD=VmaxD-2
and in expression
=Sum({$<Year={"<=$(=VmaxD)>=$(=VminD)"}>}Fieldname)
-Regards
premhas
thanks