TEXT to return "0 / 0%"

[_eNVy_]

I have a need to return a combination of two figures in a single cell, one non-decimal and another in a percentage.

=GETPIVOTDATA("Count of Reviews",'Tester'!$A$46,"Age Band","65+","Time Status","Not Overdue")&" / "&TEXT(GETPIVOTDATA("% Overall Overdue",'Tester'!$A$46,"Age Band","65+","Time Status","Not Overdue"),"#%")

For cells in my Pivot that has a higher percentage than 0 it returns what I need it to (eg. "4 / 2%").
When it comes to values of 0% in my pivot, it only returns a blank : "0 / %"

CONCAT without the TEXT syntax returns "0 / 0". Unless I am missing something?

=CONCAT(GETPIVOTDATA("Count of Reviews",'Tester'!$A$46,"Age Band","65+","Time Status","Not Overdue")," / ",GETPIVOTDATA("% Overall Overdue",'Tester'!$A$46,"Age Band","65+","Time Status","Not Overdue"))

How can I have a return of : "0 / 0%" ?

 

[johnny51981]

Maybe try something like this?

=CONCAT(GETPIVOTDATA("Count of Reviews",'Tester'!$A$46,"Age Band","65+","Time Status","Not Overdue")," / ",if(GETPIVOTDATA("% Overall Overdue",'Tester'!$A$46,"Age Band","65+","Time Status","Not Overdue")="",0,GETPIVOTDATA("% Overall Overdue",'Tester'!$A$46,"Age Band","65+","Time Status","Not Overdue"),"%")