cancel
Showing results for 
Search instead for 
Did you mean: 

Number Formar

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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

Former Member
0 Kudos

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.***

Former Member
0 Kudos

Hi,

My Formula Invovles Only Multiplication (Annual Salary * Exchange Rate ), there i sno Division involved

cheers

Former Member
0 Kudos

Hi Vinod,

Instead of using formula variable , try using currency translation for conversion of INR to USD.

And in the conversion fixed target currency to USD.

Hope that helps.

Regards

Kapadia

***Assigning points is the way to say thanks in SDN.***

Former Member
0 Kudos

hi,

My requirement is THere should be a input variable which should accept the Dollar Rate , which the user enters as input , then i should make this to Caluclate the Annual Salary in Dollar Rate Enterd in the Inout Screen.

cheers

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi all,

See all the annual salary's are in INR i have Checked it and i have aso used NoDim Function , will it be beacuse of Shortage of Number Length.

cheers