Focal Point
[SOLVED] Where condition issue

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2747050906

August 30, 2011, 02:28 AM
Shru
[SOLVED] Where condition issue
HI All,

I am currently working on the report which needs to sum on a particular column based on the year and quarter selected.example- if the selected year is 2010 and qtr is 2, then the report should run for 2008 all quarters, 2009 all quarters and for 2010 till 2nd quarter.

I tried giving "where year LE current year" and where qtr LE curr qtr" but this will give data for all years but only for 2 qtr. I also tried merging the columns "where yr||qtr LE 20102". nothing seems to be working.
Can anyone please tell me is there a way out for this
Thanks
Shru

This message has been edited. Last edited by: Kerry,


769 Excel,PDF and HTML
August 30, 2011, 08:23 AM
jimster06
Have you considered putting your data selection logic in DEFINE?


jimster06
DevStu WF 7.6.11
W7
HTML, PDF, EXL2K
August 30, 2011, 09:03 AM
GamP
Maybe something like this:
where year lt xxxx or (year eq xxxx and qtr le y)
xxxx is the selected year, y is the selected quarter.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
August 30, 2011, 09:25 AM
Shru
Hello Everyone!!!!

Thanks for all your inputs. The issue is resolved.
I used 2 conditions to resolve the issue
where year eq 2010 and qtr lt 2
where year lt 2010
this gave the result what i wanted


769 Excel,PDF and HTML
August 30, 2011, 05:33 PM
Waz
If you have a your date and quarter in a smart date, you can test directly.

TABLE FILE GGSALES
PRINT *
COMPUTE Qtr/YYQ = DATE ;
WHERE TOTAL Qtr LE '1996 Q2'
END



Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!