help needed in solving this requirement

[fashid]

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

[fashid]

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

[fashid]

Can Anybody please reply

[PrashantSangle]

Hi,

can you tell me ,What is your expected output in % column?

Regards,

PS