Skip to Content
0

No Value return for Where function

Oct 21, 2016 at 04:07 PM

10

avatar image

I am using BO 4.1. I am trying to get the total controllable write off (it will the same) for all types of AR code. And it will be 3927.26 by following formula. However when I drag it to those AR code, the formula shows up but no data return. It worked well when I drag it separately (right table)

Formula:

=([Query 6.2 Write-Off Total].[Credits] Where ([Query 6.2 Write-Off Total].[Write Off Category] = "Controllable")) +([Query 6.2 Write-Off Total].[Discounts] Where ([Query 6.2 Write-Off Total].[Write Off Category] = "Controllable"))+([Query 6.2 Write-Off Total].[Contract Adj] Where ([Query 6.2 Write-Off Total].[Write Off Category] = "Controllable"))+([Query 6.2 Write-Off Total].[Bad Debt] Where ([Query 6.2 Write-Off Total].[Write Off Category] = "Controllable"))

However, if I sum those measures without adding the where function as the second formula(=[Query 6.2 Write-Off Total].[Credits]+[Query 6.2 Write-Off Total].[Discounts]+[Query 6.2 Write-Off Total].[Contract Adj]+[Query 6.2 Write-Off Total].[Bad Debt]), there is data returned. But it is not the one I want. I need it pick up the controllable write off only.

temp2.png (22.6 kB)
temp1.png (24.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers