Skip to Content
0
May 23, 2018 at 08:12 AM

How to exclude empty rows with string values

187 Views Last edit May 23, 2018 at 11:19 AM 3 rev

capture123.pngHi Experts,

I have a key figure (QTY YTD P1) in webi (Type:string; Aggregation:Delegated) and it shows some cells as empty. My requirement is to first exclude empty rows and then get percentage each field with total amount for cashier name. Screen shot of the table is attached. I think there are two challenges first thing is get the string to format number and then to exclude or convert empty cells.

Please suggest best possible way to get results.

Attachments

capture123.png (23.6 kB)