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),‘%’)

Replace blank/NULL values by 0

crizar January 24, 2024, 9:09am 5

This worked! Thank you so much!