Guest User

Untitled

a guest
Jan 23rd, 2018
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. Function SumLookup(ByVal items As Object()) As Decimal
  2. If items Is Nothing Then
  3. Return Nothing
  4. End If
  5. Dim suma As Decimal = New Decimal()
  6. Dim ct as Integer = New Integer()
  7. suma = 0
  8. ct = 0
  9. For Each item As Object In items
  10. suma += Convert.ToDecimal(item)
  11. ct += 1
  12. Next
  13. If (ct = 0) Then return 0 else return suma
  14. End Function
  15.  
  16. =Code.SumLookup(LookupSet(Fields!sJerarquiaNivel2.Value,Fields!Unidad.Value,Sum(Fields!InventarioSobreVentas.Value, "DS_DataInventarioDosAniosAnterior"))
Add Comment
Please, Sign In to add comment