mercredi 15 juin 2016

NetSuite Formula Percentage and Case When

Field Summary Type Formula Customer Group
Formula (Text) Group Case {custrecord1} When'15' Then'A' Else 'B' End
Customer ID Count

The above results group the customers and provide a count of A vs B customer records. Is there a way to return the percentage of A vs B records (customer ID count) for each customer instead of showing it as a percentage of Total by using the formula (percentage) function?

Aucun commentaire:

Enregistrer un commentaire