Hi! I’m creating a WBR visual with the Receive Accuracy metric. The logic for RA metric is= POs correctly received/total POs There are some weeks where we don’t have any POs delivered in specific regions, so we have rows for that week with null values. [RA_wbr] I want to substitute those null val…

Quick and dirty: you could do concat( tostring(your calculation*100),‘%’)

Hey crizar, the problem is that you try to use a string and a number as output in your calculated field. You could try to put the else statement in a tostring function but i am not sure if it will be enough. If this won’t work: try to separate the calculation in an different calculated field and…

Thanks Robert for your answer. This makes sense. But if I convert to string my output from the PO Receive Accuracy metric, the number will not be in percent and I can format it as it’s recognized as text. Any idea on how to fix that? [RA_QS]

Hi @crizar could you pls solve the topic if @robert.eibers solution works. BR

Sorry I thought I already did. Done now. Thanks.

Hello, I am trying to do the same to replace “black cells” with 0.00% to have a consistent format. Below is what the table looks like when I tried to do the - [concat(tostring(your calculation*100),‘%’). [Capture] Here is what I have in my calculated fields: concat(toString((sum(Defect)/sum(Defec…

Hi @prazon what if you round the value before converting into string? BR

Checking if I understood your question correctly. Do you mean embed in the formula to round the value first? Below is the original format I have with a simple formula applied in calculated field - sum(Defect)/sum(Defect+Clear). As you can see, there are blank cells. I wanted to replace those blank c…

Replace blank/NULL values by 0

Q&A

crizar January 24, 2024, 9:09am 5

This worked! Thank you so much!

How to add both % and absolute values under the same cell in the Pivot Table Chart

Topic		Replies	Views
Replacement of NULL values not working Q&A analysis , formatting , quick-sight , visuals , Business-Intelligence-Engineer	2	100	March 18, 2025
Table error Q&A analysis , quick-sight , calculations , Business-Intelligence-Engineer	6	203	January 10, 2024
Formatting empty value cell in pivots Q&A formatting , feature-request , quick-sight	8	2446	July 26, 2023
Replacing Empty Cells Q&A error , quick-sight , calculations	2	413	March 10, 2023
Showing 0s in pivot table for data that doesn't exist Q&A formatting , quick-sight , Business-Intelligence-Engineer	4	165	May 7, 2025

Replace blank/NULL values by 0

Related topics