H
Hassan
Can some one help me with logical function for the following
WC QC Sub App % Complete
70% 10% y or n y or n
100% 100% y ---
100% y ---
Basically first column is work completion for me (70% weightage), second
column QC check (10% weightage) and this column is Submission (10% weightage
and denoted by “y†or “nâ€) and forth column is Approval (10% weightage and
denoted by “y†or “nâ€)
Technically once the Work is completed it should go to QC and so on and for
calculation it should not consider the values if previous stage is not
complete.
Logically I want answer in % Complete as
70% of 100% of WC+10% of 100% of QC (WC being 100 for that row)+10 (if it is
“y†in sub column and WC & QC being 100 for that row)+ 10 (if it is “y†in
App column and WC, QC being 100 and “y†in “Sub†for that row)
If any condition does not satisfies it should terminate summation upto
previous column
Thanks on & All for being on this platform
Hassan
WC QC Sub App % Complete
70% 10% y or n y or n
100% 100% y ---
100% y ---
Basically first column is work completion for me (70% weightage), second
column QC check (10% weightage) and this column is Submission (10% weightage
and denoted by “y†or “nâ€) and forth column is Approval (10% weightage and
denoted by “y†or “nâ€)
Technically once the Work is completed it should go to QC and so on and for
calculation it should not consider the values if previous stage is not
complete.
Logically I want answer in % Complete as
70% of 100% of WC+10% of 100% of QC (WC being 100 for that row)+10 (if it is
“y†in sub column and WC & QC being 100 for that row)+ 10 (if it is “y†in
App column and WC, QC being 100 and “y†in “Sub†for that row)
If any condition does not satisfies it should terminate summation upto
previous column
Thanks on & All for being on this platform
Hassan