Hi Experts,
I am facing problem when i ahow to read the values from actual area(actual values).
My req is like i have two planning areas as follows..
1 Basic Cube Planning area.(Actual)
2.Transactional cube planning area(Plan).
I created Multi-planning area from above two planning areas.
I have a Actual value in Basic Planning area (i created a layout and i restricted planning area - actual).
now i want to distribute actual value in to second planning area(i created a layout and i restricted planning area - Plan).
As per my req i am using two layouts because i have some other fields also client don't want on same layout actual and plan,they need different layouts.
How can i read Actual value here i am using Fox code to distribute the values.
Ex: I have a week1 actual value $7000.
dayUsing fox code distribute above value to my week days
day1 day2 day3 day4 day5 day6 day7 total
$1000 $1000 $1000 $1000 $1000 $1000 $1000 $7000.
and also i have to check actual value and sum of week days value should be equal if greater i have to pass error message(how can i??).
here i created dynamic layout for week days.
Can your share ideas and if you have sample code also please
I'll assign full points ....
Thanks.