Skip to Content

Bucket in webi

Hi Experts,

I am facing a strange error:

We have following table with DTI(report level variable).

DTI<.40=Count([Query 2].[Lead Id] Where([DTI]<0.4))

DTI >= .40 & <=.45=Count([Query 2].[Lead Id] Where([DTI]<=0.45 And [DTI]>=0.4 )) ForEach([Case Completed MonYear])

It shows the values correctly.

However once I remove lead id from this it shows following

As you can see in above image we have a lead DTI>.7 and 1 in .5 & .7.

My report need the last table but its not showing the count correctly.

I tried using foreach on lead id or case completed mon year but it doesnt work.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 20, 2017 at 11:32 PM

    Is there any reason why you have an inconsistent calculation context across Finance cost and Total annual income? Have you tried refactoring your formulas to remove the ForEach from Total annual income and make DTI something like "=([Finance cost] / [Total annual income] For Each([Query 2].[Lead Id])"

    Add comment
    10|10000 characters needed characters exceeded