Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
This is in reference to my Previous post over here Urgent help required in solving this problem
I am facing an issue in solving this requirement. i need to find the percentage of the no of days elapsed
eg the calculation should be as:-- the difference between the 'difference' column where SMS TYPE is 4 and SMS TYPE is 2 divided by
the difference column where SMS TYPE is 2 for a particular DOC NO
for eg:-- in the qvw app that i have attached, in the bottom most chart for do3 DOC NO the calculation should be
(4-2)/2*100 (I am referring to the difference column) in the bottom chart
Thanks And Regards
SHaikh Nadeem
Hi,
I have worked on the above and produced the required output using the expression "IF([SMS TYPE]=4,(difference-Above(TOTAL (difference)))/Above(TOTAL (difference)))"
Now if anybody could just help me out in averaging the values in the percentage column considering only KVPS i Have tried to do that but failed
If you need any clarification please let me know
Regards
Shaikh nadeem
Can Anybody please reply
Hi,
can you tell me ,What is your expected output in % column?
Regards,
PS