on 03-14-2007 8:59 AM
Hi all,
I am deispalying the Headcount of each Department in Organization along with the Annual Salary in INR, in Addition to that i am Dispaying the Annual Salaray in Dollars also using Formula Variable.
But here i facing a Problem where for all particular Department if the Annual Salary is "4.024.992,00" with Head Count as "5" now i fi dispaly the Same value in the Dollars after multilying with Value Accepte in hte Formula VAriable it is showing as "X". but if drill down to employee in department wise then the Annual Salary in Dollars is getting Dispalyed correctly.so how to display the Annual salry in Dollars
Cheers
Hi,
Is the Formula variable has processing type as Replacement path with one of the attribute of Employee.
Then to avoid this problem,if there is no EMPLOYEE cahracterstic in the rows ,take a look on how to calculate with attributes Document available in Service market.
With rgds,
Anil Kumar Sharma .P
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vinod Kumar ,
'X' means somewhere system is doing divide by Zero in the formula.
Check the formula once again.
Hope that helps.
Regards
Kapadia
***Assigning points is the way to say thanks in SDN.***
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Generally the X means that in total there are diffrent currencies; you have to use nodim(kf) function to remove the currencu ID.
Hope it helps.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.