set analysis expression

[Anonymous]

i need to calculate :

based on one field

U=

x-y/x+y+z

want to calculate U based on count(id)

[Anil_Babu_Samineni]

Would you describe more, Please?

[Anonymous]

suppose i have values for id

2

3

5

6

7

8

which are associated to field x,y and z

now i want to calculate U bsed on above formula

count of x,y,z based on id

and x,y,z are texts

[Anil_Babu_Samineni]

How do i know which values are associate with x,y,z over here?

May be create two columns as static and then explain business and tell us required output. So that we can tack easily. You mentioned x,y,x are texts.

May be this?

(Count({<U = {'x'}>}id)-Count({<U = {'y'}>}id))/(Count({<U = {'x'}>}id)+Count({<U = {'y'}>}id)+Count({<U = {'z'}>}id))