Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am facing problem in set analysis for a expression.
I am attching one QVW file and one excel file, by which you can understand my problem.
Pls give me needfull sugestion.
Thanks in advance.
Sukamal Naskar
Hi,
I changed something in the script to get the right data.
Succes, Halmar
Altering ur second expression like this will get u the result
sum({<Season={$(=Max(Season)-1)},MonthNo={"<=$(=Max({<Season={$(=Max(Season))}>}MonthNo))"}>}Val)
If i have not understood ur issue please let me know
Hi,
I changed something in the script to get the right data.
Succes, Halmar
I want to take comapny wise maximum month number....not max(monthno) of all garden.
In 2011 Company A has max(MonthNo)=6 val=160
In 2011 Company B has max(MonthNo)=9 val=250
Here maximum MonthNo is coming 9
i want to show 2010 record like this
In 2010 Company A has max(MonthNo)=6 val=210
In 2010 Company B has max(MonthNo)=9 val=290
Here maximum MonthNo is coming 9
By default selection ..... means clear all field.
Please see my excel sheet.
Thanks a lot halmar.
Nice job you have done.