NPrinting Formula

fcecconi — Fri, 10 Aug 2018 17:58:21 GMT

I am trying to create a formula to be used in the excel output, but the value being displaying is always 0. The formula is this: =SUM(CPBH)

Here is the code for CPBH:

Name: Num#(IF(Wip_Type='CPBH',Quantity,0))

Description: CPBH

I created a KPI object in the the source document as Sum(Num#(IF(Wip_Type='CPBH',Quantity,0))) and a value is produced.

Any idea why I keep getting 0?

Re: NPrinting Formula

Ruggero_Piccoli — Tue, 18 Sep 2018 10:25:37 GMT

Hi,

I added a Formula very similar to yours into a template and it is working fine. I have a 0 result only after adding a filter that excludes all the row for the selected category.

So check if you have a filter that is excluding all the rows with Wip_Type='CPBH'.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

topic NPrinting Formula in Qlik NPrinting

NPrinting Formula

Re: NPrinting Formula