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.