Fiscal Calendar

[jjking58]

Please advise,

I created a fiscal calendar using the code below. Over the file listed below. They look to be attached at IHIDAT, but none of the other fields in the table seem to be connected to the calendar . When I make fiscal year selections the  other fields in the file they do not change.

Thanks,

Jim

[jjking58]

Sunny,

Were you able to make anything out of the screen shots i sent

Thanks

Jim

[sunny_talwar]

What is the expression for current year for which you are looking to get the previous year?

[jayanttibhe]

Hi,

Create one more dimension for Year in your script. (Just take first 4 characters from the IHIDAT).

You need to use following expressions for :

Current Year    :;    Sum({$<Year={$(=max(Year))}>}Price)

Precious Year   ::   Sum({$<Year={$(=max(Year)-1)}>}Price)

Thanks

Jayant

[jjking58]

Sunny/Jayant,

I already have a "Year" setup in my script( see original request attached above).

Here are my expressions. I placed the previous year expression into the line and show no data displays.

Please advise

Thanks

Sum({<IDPAGR = {'EQUP'},OrderType-={'TI'},Year={$(=max(Year)-1)},NOAGRP-={'INTR'}>} Amount)

Sum({<IDPAGR = {'EQUP'},OrderType-={'TI'},Year={$(=max(Year)-1)},NOAGRP-={'INTR'}>} Cost)

Column(1)-Column(2) = for GP

[jayanttibhe]

Well - Difficult to look in without QVW file.  Try above expression in text box object and try to trouble shoot only with the year field. 

Thanks

Jayant

[jjking58]

Jayant,

I've tried  trouble shooting as you suggested and have the same results. I not sure I'm understanding what to do. I created a field in the fiscal calendar call "Year" based on field IHIDAT. When I test do i use Year or IHIDAT (since there both the same field). Please explain this

Thanks

Jim