Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
Does anyone know how I can get the Dual() function to do what I want?
I want to be able to show both the percentage and the actual number.
In the qwv I have included in test3 is where I do not understand why it does not show me the number and the percentage.
Can someone please help me?
Thank you
I don't think this would be possible, because as soon as your set Integer as formatting the Dual's text part is replaced by its number part in the display.
Like this?
Hi. No cause it still goes back to original when I change the format. I might have more than 1 expressions and need the pop up label to reflect the value of the exact bar (line).
I have survey question where the user needs to analyze on the percentage answered but also wants to see how many answered. So the numerator.......
Hi kjersti,
you'd better leave the number setting for the dual function as 'Expression Default' otherwise the dual function doesn't work.
For your expression test3 take: Avg(Amt)/Sum(Amt), for the second expression this is the right way:
Dual( Num(Avg(Amt)/Sum(Amt),'##.##%') &' / ' & Num(Avg(Amt), '#,##0'),Avg(Amt)/Sum(Amt))
See the picture:
Hope this helps
Burkhard
Attached a sample with multiple expressions.