Custom metric issue, eg. A-B when A dosn't exist it returns a value of -B

Rod_Pestell · 2021-09-21T20:53:02+00:00

Hi All,I have (or maybe now had) a problem with custom metrics. I am subtracting a field from another (eg. NPS - target). The targets are setup for each period for the whole year. As it's only September, the targets display for October, November and December but NPS is blank (it appears as a hyphen '-'), which is fine. the problem is that the custom metric that subtracts NPS from target still calculates so it's treating the blank '-' like a zero. I wondered how I could hide a custom metric if NPS was blank. Perhaps by some clever maths? My only slight thought is what if NPS is zero but let's not worry about that just yet!I managed to get this working by using this formula in the custom metric=(nps-target)-(nps/nps*0)This seems to work but as mentioned what if the NPS calulates to be 0. Putting in a fiddle factor (eg.+ 0.0000000000001) might work but I guess I'll have to wait for a zero NPS.Does anyone have any thoughts?ThanksRod Pestell

Custom metric issue, eg. A-B when A dosn't exist it returns a value of -B | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded