|Resseting Place Holder Value [message #409055]
||Fri, 19 June 2009 02:01
Registered: March 2008
Location: Mumbai ,India
I have one report which contains three group
1] Main Group
Here i fetch customer related info.
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