Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Sum of Variables

Hi all,

I am developing a report that have sections by profit centers.. and its subtotals.

I created 2 new columns aside subtotals and I filled with 2 variables:

1-) =If (Sum([Main].[Montante]*[Perc].[Montante])) > 0 Then (Sum([Main].[Montante]*[Perc].[Montante])) Else 0

2-) =If (Sum([Main].[Montante]*[Perc].[Montante])) < 0 Then (Sum([Main].[Montante]*[Perc].[Montante])) Else 0

I need to sum those values and store on another variable that I will use soon. But I have a problem: Webi doesn't allow to sum by itself, so I did it manually and the result is not according to the real sum.

Does anybody has any idea about how to I can do this?

Thanks in advance.

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question