To Capture a reason owing to specific type!

[nevilledhamsiri]

Dear Sunny or any one from our community,

This refers to some data arranged as per some prearranged plan. I need to apply reason where Branches visited=0. For that I have given a reason through variable overview window (VReason1 with definition 'owing to flood'. To pick this reason the expression given too presented here. But it looks like an error associates.

IF(Set_Month='Jun' and sum(aggr(COUNT(DISTINCT([Person visited])),[place to visit],[Place visited]))=0,Concat(VReason1))

I prefer if Dear Sunny responds to this particularly because she has been continually proposing answers to this issue from the point where I started!

Neville

[Colin-Albert]

See Attached

[nevilledhamsiri]

Dear Colin,

This expression pick the reason I need. Simillarly  I  need to add any other reasons through variables such as for late visits etc can this expression be used if so what change be made to this expression.I have included the reason please  suggest the expression to pick it up.

Many Thanks

Neville

Attached the qvw

IF(Set_Month='Jun' and sum(aggr(COUNT(DISTINCT([Person visited])),[place to visit],[Place visited]))=0, Type_Of_Visit & ' ' & VReason1)

[nevilledhamsiri]

Please find the attachment