Dual in Expression

[george456]

Dear Community

I am having not output with the below:

=dual( Sum(({<Year={$(=max(Year))},MONTH={$(=MONTH(LatestDate))}>}$(vMeasure))/1000) & ' (' & num((sum({<Year={$(=max(Year))},MONTH={$(=MONTH(LatestDate))}>}$(vMeasure))/sum({<Year={$(=Year(LYY))},MONTH={$(=MONTH(LYM))}>}$(vMeasure)))-1,'##.0%'))

Can I please ask for some guidance 

Regards

[rwunderlich · Accepted solution]

First of all, Dual() takes two parameters and I think I only see one on your expression.

I suggest you break down the expression into smaller pieces and determine what s working and what is not. 

-Rob