Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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