Page 1 of 1

FSG

Posted: Fri Jul 03, 2009 2:40 am
by Rizwan.Mumtaz
If i have two columns in my colum set as follow:

Col-1 & Col-2
May-09 & Apr-09
PTD & PTD


Now i have a row set and one row is as following:


Opening Profit b/f
(having, Amount type YTD, with 0 offset)


Now result of this row is fig.of May Ytd & fig.of May Ytd

The above result is wrong

The result should be as: fig.of May Ytd & fig.of Apr Ytd

how can i do this, Please some one give the solution in this regard.
Thanks to all.

Posted: Sun Jul 05, 2009 3:42 am
by hiszaki
HI Rizwan

Try to make the col period PTD with offset 0 for may & offset -1 for period Apr. then run again.

Thanks
Hisham

Posted: Fri Jul 24, 2009 4:07 am
by Rizwan.Mumtaz
Hi Hisham

No it dos'nt work and it could'nt be, as i confirm it from metalink.

Thanks for ur help

Posted: Sun Jul 26, 2009 4:33 am
by sudhir
Hi,

If you desire YTD, then the Amount Type for your columnset definition must be YTD - Actual.
Then you could use the offset 0 and -1 for the 2 columns respectively.

See if this works