Monday, March 26, 2012

especial SUM

I wonderin if I can make this type of sum in SQL Reporting Services.

sum( iif(Fields!ESTADO_TRANSAC_POS.Value = "V",Fields!TOTAL_GENERAL.Value,cdbl("0.00")),"source")


i get an error field : (

i dont want to sum all the rows just the ones that where Estado_Transac = "V"

can you help me : )

i found the answer in this thread Conditional Sum/Runnining Total

sql

No comments:

Post a Comment