CODEWITHSUNDEEP
business-objectswebi
ECEUK
ECEUK

Reputation: 1

Webi 4.1 BO variable not aggregating

I have created a measure variable:

= If IsNull([OBJECT 1]) And IsNull([OBJECT 2]) Then 0  ElseIf

Not(IsNull([OBJECT 2])) Then 

DaysBetween([DATE 1];[DATE 2]) 

Else 

DaysBetween([DATE 1];[DATE 3])

This works fine when the Unique Object is present but when I remove the unique ID I expect it aggregate but I get Multivalue. Please advise how best to correct this?

Thank you for your time in advance.

I have tried ForEach () to the Unique ID but still not getting what I need. I want a separate table with my Sum Count etc. as a dynamic Summary but getting Multivalue. This should be simple but it's creating a big headache !!!

Upvotes: 0

Views: 192

Answers (1)

Isaac
Isaac

Reputation: 3363

If you wrap your formula in a Sum() function...

enter image description here

That should do it...

enter image description here

Upvotes: 0

Related Questions