topic Re: Set Analysis Problem in App Development

Set Analysis Problem

shakil4sk — Tue, 02 Apr 2019 16:07:51 GMT

I have created a Previous Year YTD measure

Sum({$<[Transactions.Account Type]={'Expense','Income','Cost of Goods Sold'},
[Transactions.Txn Date] = {">=$(=AddYears(YearStart(Max([Transactions.Txn Date])),-1))<=$(=AddYears(Max([Transactions.Txn Date]),-1))"}>}[Transactions.Amount With Sign])

when i select year filter it shows 0 but when i select month it shows correct value.

i could not figure out the problem.

Please help

Re: Set Analysis Problem

sunny_talwar — Tue, 02 Apr 2019 16:23:01 GMT

What is the your year field called? Assuming it is called [Transactions.Txn Year], try this

Sum({$<[Transactions.Account Type]={'Expense','Income','Cost of Goods Sold'},
[Transactions.Txn Date] = {">=$(=AddYears(YearStart(Max([Transactions.Txn Date])),-1))<=$(=AddYears(Max([Transactions.Txn Date]),-1))"}
, [Transactions.Txn Year]>}[Transactions.Amount With Sign])

Re: Set Analysis Problem

Vegar — Tue, 02 Apr 2019 16:25:59 GMT

Your year selection is affecting your expression. You need to cancel out year

Sum({$<
Year,
[Transactions.Account Type]={'Expense','Income','Cost of Goods Sold'},
[Transactions.Txn Date] = {">=$(=AddYears(YearStart(Max([Transactions.Txn Date])),-1))<=$(=AddYears(Max([Transactions.Txn Date]),-1))"}
>}[Transactions.Amount With Sign])

Re: Set Analysis Problem

shakil4sk — Tue, 02 Apr 2019 16:30:42 GMT

Nope, I don't have [Transactions.Txn Year] field but i got the point.

Ok thanks a lot