Another Set Analysis Question

[#1]

Hi all,

I am working on this report and I am running into a wall.

This report asks the user to select a State, City, and then a store. Based off that selection it lists other stores near by and calculates the distance from the selected store.

It works great.

But here is the issue, I am trying to do a count of orders at the stores listed by doing the following:

=if($(vCalc) > 0 and $(vCalc) <=$(vRadius),Sum(Orders_Counter))

in an expression. This is a straight table which I'll eventually turn into a like graph. The dimension are the StoreNames.

The issue is that that expression alone wont allow the data to show. But I need to add another expression with just one inside it to get the storenames and the =if($(vCalc) > 0 and $(vCalc) <=$(vRadius),Sum(Orders_Counter)) to even show in the straight table.

Is there another way around adding this extra expression?

[its_anandrjs]

You can try this

Sum(if($(vCalc) > 0 and $(vCalc) <=$(vRadius) , Orders_Counter))

[#3]

I think that I would need to ignore selected:

SUM(if($(vCalc) > 0 and $(vCalc) <=$(vRadius),{<StoreName = >} Orders_Counter))

But the above is not getting it either

[#4 · Accepted solution]

Got it

if($(vCalc) > 0 and $(vCalc) <=$(vRadius), SUM({<StoreName = >} OrderTest_Counter))