Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i need to calculate :
based on one field
U=
x-y/x+y+z
want to calculate U based on count(id)
Would you describe more, Please?
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
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))