Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
paulabeni
Contributor
Contributor

sum with exclusions

Hola, tengo una formula con 3 exclusiones y necesito añadir una en la cual, solo quiero los valores superiores a cero del campo "InvoicePosition_UnitPrice", no consigo sacar el dato, ¿me podéis ayudar?

Copio la formula con todas las exclusiones en la que falta el campo >0

=sum({<BU_Level_INV = - {'Logistica', 'Finanzas'},
Mg_ExternalID_INV = - {'COD_PFB_5498', 'COD_JJJ_5490','COD_GFB_3212'},
Supp_Name = - {'TESTING SUPPLIER S.L.', 'SECOND TST SUPP S.A.'}>}

(InvoicePosition_UnitPrice*InvoicePosition_Quantity)+InvoicePosition_TaxAmount)

Labels (3)
1 Reply
Kayde_72
Contributor III
Contributor III

Hola, no hablo español pero creo que en general entiendo. Prueba esto

 

=sum({<BU_Level_INV = - {'Logistica', 'Finanzas'},
Mg_ExternalID_INV = - {'COD_PFB_5498', 'COD_JJJ_5490','COD_GFB_3212'},
Supp_Name = - {'TESTING SUPPLIER S.L.', 'SECOND TST SUPP S.A.'},

InvoicePosition_UnitPrice={">0"}>}

(InvoicePosition_UnitPrice*InvoicePosition_Quantity)+InvoicePosition_TaxAmount)