Issues due to nulls

[kishorj1982]

Hi all,

PFA.

I have nulls in my  ActiveInactiveFlag.

for handling those I use pick match function.

But still value after'All' selection are not matching in active inactive flag.

My requirement is values after clear all and values after selecting All option for sum(CollectionAmount) should match.

Please suggest.

thanks

[PrashantSangle]

I am getting same value after clear all selection and by selecting ActiveInactiveFlag as 'All'

It is -950761.74431.

Regards,

[kishorj1982]

I have uploaded the new file.

Thanks

[PrashantSangle]

add all values in pick(match()) against all search type

Regards,

[stabben23]

If you look into ActiveInactiveFlagtemp Field, everything looks to work.

Maybe try to delete this part:

Flag:
Load ActiveInactiveFlagtemp,
ActiveInactiveFlagtemp as ActiveInactiveFlag
Resident  AddressBook;
Concatenate
Load ActiveInactiveFlagtemp,
'All' as ActiveInactiveFlag
Resident  AddressBook;

[kishorj1982]

That part is required.

Because for All the values should be there after selection for All option in Active inactive flag.

Thanks,

[kishorj1982]

RhanksWe need to show C , CP for Active selection.

Cx for inactive selection.

C,CP,CX and NULL in All selection.

In pick match function we are not able to repeat the values so I used

Flag:
Load ActiveInactiveFlagtemp,
ActiveInactiveFlagtemp as ActiveInactiveFlag
Resident  AddressBook;
Concatenate
Load ActiveInactiveFlagtemp,
'All' as ActiveInactiveFlag
Resident  AddressBook;

Thanks

[sunny_talwar]

What exactly are you trying to do here?

Pick(match(Search_Type,'C','CP','CX',''),'Active','Active','Inactive','All') as ActiveInactiveFlagtemp,

This is showing up as this...

Is this something you expected to see?

[kishorj1982]

Whenever I am selecting All values for search type C,CP,CX ,'' also need to be displayed.

For Active-c,cp

Inactive-cx

all- C,CP,CX ,and blank

[sunny_talwar]

What about other Search_Type? J, U, E, B, EX, V? Those don't need to be selected?