Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I guess it could be something related to execution scope issue. Could you share a sample app to investigate?
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))