topic Re: Set Analysis Numerator, Denominator and Difference correct but % not working in App Development

Set Analysis Numerator, Denominator and Difference correct but % not working

Ja123__ — Sat, 16 Nov 2024 06:50:00 GMT

Hi there

I want to display the difference amount as a % of the old/PY value.

I haven't had this issue before and think it may have to do with this measure that I inherited from the old QV model.

As you can see below I have commented out the divided by old as that is where it stops working? Am I interpreting something wrong. I did this on another model with a simple measure and basic set analysis and it worked fine?

(Sum({<[Transaction Date] = {"<=$(=vMaxTDate)"}>} If(Effect = 'Debit', [Transaction Amount], -[Transaction Amount])) //New

-

Sum({<[Transaction Date] = {"<=$(=vMaxTDatePY)"}>} If(Effect = 'Debit', [Transaction Amount], -[Transaction Amount]))) //Old. Previous year.

//    /Sum({<[Transaction Date] = {"<=$(=vMaxTDatePY)"}>} If(Effect = 'Debit', [Transaction Amount], -[Transaction Amount]))) //Old. Previous year.

Re: Set Analysis Numerator, Denominator and Difference correct but % not working

pasi_lehtinen — Thu, 17 Jan 2019 08:30:34 GMT

Hi,

Seems like you have an extra closing parentheses in the end of the expression.

- Pasi

Re: Set Analysis Numerator, Denominator and Difference correct but % not working

jonathandienst — Thu, 17 Jan 2019 08:32:05 GMT

It looks like the previous year term is zero. You may need to override some date selections if you are making date selections in a field other than [Transaction Date].

You should also confirm that the variable vMaxTDatePY is what you expect and has a valid date.

Re: Set Analysis Numerator, Denominator and Difference correct but % not working

Ja123__ — Thu, 17 Jan 2019 08:36:32 GMT

Thanks for your response Jonty

Re: Set Analysis Numerator, Denominator and Difference correct but % not working

Ja123__ — Thu, 17 Jan 2019 08:37:08 GMT

Thank you!!!!! Cannot believe it was that.