How to use and "If" statement with Set Analysis

[#1]

Any ideas on why this expression is not working for me? Thanks!

Note: vSA_IgnoreSKUToggle and vSA_IgnoreBranchPlantToggle are variables set by users.

=
if
(
vSA_IgnoreSKUToggle = ' ' AND vSA_IgnoreBranchPlantToggle = ' ',
sum(
{$<Branch_Plant = , SKU = >}
Inventory_Snapshot.On_Hand_Saleable_Quantity)
,0
)

[erichshiino]

What kind of results did you get?

I understand that if your variables are a single space ' ' you make set analysis ignoring selections in two fields, right?

Maybe you should test your variables for blanks '' or even nulls ( isnull(vSA_IgnoreSKUToggle))

Maybe you should evaluate your variable before testing it $(vSA_IgnoreSKUToggle) = ''

[#3]

I counted the length of the variables and that is working for me now. Thanks anyway.

if

(
//// 1 = Global, 2 = Selected
len(vSA_IgnoreBranchPlantToggle) =1 AND len(vSA_IgnoreSKUToggle)= 2 ,
sum(
$(vSA_GlobalLocationsandSelectedProducts)

Inventory_Snapshot.On_Hand_Saleable_Quantity)

[neetu_singh]

Hi,

you can use your expression like this:

=sum(
{$<Branch_Plant = , SKU = >}if
(
vSA_IgnoreSKUToggle = ' ' AND vSA_IgnoreBranchPlantToggle = ' ',
Inventory_Snapshot.On_Hand_Saleable_Quantity)
,0
)

it will work, if not then let me know

Regards

Neetu Singh