Skip to Content
0
Former Member
Nov 07, 2017 at 04:30 PM

Crystal Report cross tab percentage

101 Views

May someone can assist me - I have calculated percentage of each row for the cross tab below but I need only percentage of one row, can I ahieve it without hiding the rest of the rows? I have created this formula but I need only the values to be displayed for "Completed Within SLA"

if {F_TASKS.TA_EST_DATE}>=currentdatetime and
({F_TASKS.TA_STATUS}="ACTIVE" OR {F_TASKS.TA_STATUS}="ASSIGNED") then "Ongoing Within SLA "
else if {F_TASKS.TA_EST_DATE}
<currentdatetime and ({F_TASKS.TA_STATUS}="ACTIVE" OR {F_TASKS.TA_STATUS}="ASSIGNED") then "Ongoing Failed SLA"
else if {F_TASKS.TA_EST_DATE}>={F_TASKS.TA_FINISH_DATE} and ({F_TASKS.TA_STATUS}="COMPLETE" OR {F_TASKS.TA_STATUS}="HISTORY") then "Completed Within SLA"
else if {F_TASKS.TA_EST_DATE}<{F_TASKS.TA_FINISH_DATE} and ({F_TASKS.TA_STATUS}="COMPLETE" OR {F_TASKS.TA_STATUS}="HISTORY") then "Completed Failed SLA"

Attachments

capture.png (13.9 kB)