hi all,
i want to calculate the no.of the days in each month based upon period number...
So in metadata, Days as account is there...
i have written rule such a way like this..
sub calculate()
select case hs.period.number
case 2
if hs.year.member mod 4=0 then hs.exp "A#Days=29"
if hs.year.member mod 4<>0 then hs.exp "A#Days=28"
case 4,6,9,11
hs.exp "A#Days=30"
case else
hs.exp "A#Days=31"
end select
end sub
when i tried this rule , getting no errors.. it's fine.
in my point of view, i took Days account as Row side, Period Dim as column side in data grid
So what i try to say is How to check this calculated data with respect to accounts as well as entities like POV to take data grid.....
if any body come across this type of scenario , please let me know the solutions ...
Thanks in advance