Counting rows and showing "N/A' when If is false

[Willo]

Hello everyone,
I'm counting rows in a collection based on the data showing in a label of a gallery and columns in the collection. This is what I'm using today and it works. The only issue is that this will show 0% if there are none as well as if the count comes back as 0%. Wondering if there is away to have it show "N/A" is the count comes back as NULL.
 
Text(CountIf(SiteRTWData,RTWCompleted.Value="Yes",Manager=Title10_10.Text)/ ((CountIf(
        SiteRTWData,RTWCompleted.Value="No",Manager=Title10_10.Text)+CountIf(
        SiteRTWData,RTWCompleted.Value="Yes",Manager=Title10_10.Text))),"[$-en-US]#,#0.0000")*100 & "%"

[rsaikrishna]

@Willo 

You can place below entire formula in the label's Text property as below:

UpdateContext( { varFormulaValue:  Text(CountIf(SiteRTWData,RTWCompleted.Value="Yes",Manager=Title10_10.Text)/ ((CountIf(
        SiteRTWData,RTWCompleted.Value="No",Manager=Title10_10.Text)+CountIf(
        SiteRTWData,RTWCompleted.Value="Yes",Manager=Title10_10.Text))),"[$-en-US]#,#0.0000")*100 & "%" } )

if( varFormulaValue = "0%", "N/A",varFormulaValue)

Give a try and let me know if you run into any issues.

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.