Skip to Content
Former Member
May 04, 2016 at 02:07 PM

How to resolve the incorrect aggregated values resulting due to formula(count) in webi?


Hi All

Please help me out in resolving the following problem( Well this post may seem repetitive,but I am stuck😔).

Following is my sql requirement in (Query in sql server) along with output:-

Following is the corresponding BO-variable formula:

Following was the overall BO output :-

The TOPN results:-

This output is not what is expected as in the sql server, It is displaying incorrect count. The actual count for that job is 1119. Well Got this using custom sql but need to implement by the webi functionality. Please help on this Gurus🤯


sqlRequirement.png (30.3 kB)
BO Output.png (47.4 kB)
Top5 results.png (17.6 kB)