Mask several values in a report

[garias]

Hi community, is there a way to mask non null values to a single value?

This is my example, I want to show not the individual values but maybe show an "X" where the value is not a null.

In that way I can show how many sales orders are made from visits to customers and just show that data in a chart.

Best regards

Gustavo Arias

[former_member497128]

Dear Gustavo,

To fulfill this requirement "In that way I can show how many sales orders are made from visits to customers and just show that data in a chart.", you can use result option in such a way that it can display the total of all the sales order as per your business need.

Please try to use result option on counter or may be other relevant key figure and let us know if this helps.

Regards,

Saurav Kumar

[garias]

Thank you saurav.kumar02, I tried another way and I think it worked.

I created a ratio that calculates how many Sales Order have a Not Null value in the Precedent Visit field, and it worked.

Best regards

Gustavo

[former_member497128]

That's great ☺️☺️