C4C Analytics - Hide DIV0 in report

[tcheuk]

I would like to get advice on how to hide this line with div0.

The redundant line is generated from Opportunity Header and Items but I have hidden it by key figure suppression. However it is brought up by Ratio field.

Ratio is a key figure formulated by "Actual Quantity %A Target Quantity"

How may I hide or remove this line in the report? thanks in advance.

[former_member497128 · Accepted solution]

Hi teresacheuk,

We get "DIV0" in key figure value if we are diving a value by Zero or Blank or Not Assigned. Here in your case, where ever the value of Target Quantity is either Zero/Blank/Not Assigned, we will get value of key figure "Ratio" as DIV0

With the help of data function "NDIV0", we can easily get rid of DIV0.
Please use formula as below:

NDIV0([Actual Quantity] %A [Target Quantity])

NOTE: To use formula exactly as above, first please use formula like before, put the cursor after %A and then click on NDIV0

Hope this helps 🙂

Regards,
Saurav Kumar

[tcheuk · Accepted solution]

@Saurav - [Problem Solved]


Thank you for the detailed steps.

I tried NIV0 previous and not working because I have set it wrong by clicking to both Actual Quantity and Target Quantity.



It now works well by apply NIV0 on the formula %A instead, thanks.

[mjveerhuis1]

Hi Teresa,

When I look at your print screen, without knowing the exact details of your report, I would adjust the selection.

When you add in your selection only the relevant values for the Assignment Type = e.g. Sample, the line concerning with [Not Assigned] will no longer be displayed and also the 'result' DIV0, will not be shown anymore. After you set up your selection, you also make it default for this report.

Lets us know if it works!

Kr.

MJ

[tcheuk]

@MJ - Thanks for the tips. This could only work if Assignment Type is mandated.