By pass field selection is not working with if condition/pick match

[ashwin_r]

Hello Everyone,

Below expression working fine.

sum({<[Link Date]={">=$(vCalMinDate)<=$(vCurrentDate)"},[Txn Type]={'Actual'},[Cost Center Level 2 TEXT]=>}Amount),

but when i use if condition then by-passing is not working on [Cost Center Level 2 TEXT] .

If(PerEquiVeh='Actual',sum({<[Link Date]={">=$(vCalMinDate)<=$(vCurrentDate)"},[Txn Type]={'Actual'},[Cost Center Level 2 TEXT]=>}Amount))

@swuehl, @johnw, @tresesco, @sunny_talwar, @jagan  

Kindly suggest with your inputs on this.

Thanks,

Ashwin

[tresesco]

I guess it could be something related to execution scope issue. Could you share a sample app to investigate?

[sunny_talwar]

Try this

If(Only({1} PerEquiVeh) = 'Actual', Sum({<[Link Date] = {">=$(vCalMinDate)<=$(vCurrentDate)"}, [Txn Type] = {'Actual'}, [Cost Center Level 2 TEXT]>} Amount))

Or this

If(Only({<[Cost Center Level 2 TEXT]>} PerEquiVeh) = 'Actual', Sum({<[Link Date] = {">=$(vCalMinDate)<=$(vCurrentDate)"}, [Txn Type] = {'Actual'}, [Cost Center Level 2 TEXT]>} Amount))