NPrinting Formula

[fcecconi]

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?

[Ruggero_Piccoli]

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.