| Resseting Place Holder Value [message #409055] |
Fri, 19 June 2009 02:01 |
mahantesh
Messages: 28
Registered: March 2008
Location: Mumbai ,India
|
Junior Member |
|
|
Hi All,
I have one report which contains three group
1] Main Group
Here i fetch customer related info.
Contains
CP_Cost,CP_Rev,CP_GOP Placeholder
2] Revenue group
Which calculates revenue related to file number found in main query.
Total Revenue is calucalated using summary column CS_Total_revenue
then this CS_Total_revenue value stored in to CP_Rev column
3] Cost Group
Which calculates cost related to file number found in main query.
Total Cost is calualateed using summary column CS_Total_Cost
then this value is stored in to CP_cost column
And CP_GOP =CP_Rev-CP_Cost
Now my problem is
For perticular customer there is revenue value but cost value is not there.
In that casewhile calulating GOP by GOP formula ,it taking CP_cost Value from Previous customer.
SO now i have to reset this Placeholder value of CP_Cost for every new customer.
As Cost group query is not returning any row, so i can not reset this value in this group.
Now i tried to initialised it in main group but it is not giving required effect
Can you poeple give me some idea
For refrence i am attaching RDF file
Regards
Mahantesh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
