Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Below expression work fine :-
=NUM(
count(distinct(if(inv>'800000' and inv<'899999' and CYTD,inv)))
-
count(distinct(if(inv>'800000' and inv<'899999' and LY_YTD_Flag,inv)))
)
/
count(distinct(if(inv>'800000' and inv<'899999' and LY_YTD_Flag,inv)))
it display as -0.155 , May i know how to make it display -15.5% ?
I try below it does not work :-
=NUM(
count(distinct(if(inv>'800000' and inv<'899999' and CYTD,inv)))
-
count(distinct(if(inv>'800000' and inv<'899999' and LY_YTD_Flag,inv)))
)
/
count(distinct(if(inv>'800000' and inv<'899999' and LY_YTD_Flag,inv)))
, '#.#%') &
Hope some one can advise me.
Paul
Try this:
=NUM(
(count(distinct(if(inv>'800000' and inv<'899999' and CYTD,inv)))
-
count(distinct(if(inv>'800000' and inv<'899999' and LY_YTD_Flag,inv))))
/
count(distinct(if(inv>'800000' and inv<'899999' and LY_YTD_Flag,inv))), '##.0%')
May be this:
=NUM(
count(distinct(if(inv>'800000' and inv<'899999' and CYTD,inv)))
-
count(distinct(if(inv>'800000' and inv<'899999' and LY_YTD_Flag,inv)))
)
/
count(distinct(if(inv>'800000' and inv<'899999' and LY_YTD_Flag,inv)), '##.0%')
or
=NUM(
count(distinct(if(inv>'800000' and inv<'899999' and CYTD,inv)))
-
count(distinct(if(inv>'800000' and inv<'899999' and LY_YTD_Flag,inv)))
)
/
count(distinct(if(inv>'800000' and inv<'899999' and LY_YTD_Flag,inv)) * 100, '##.0') & '%'
Hi Sunny
I have try both your expression , it display null , it does not able to convert -0.3125 to %. ( I have reload to smaller file now the value have change from -0.155 tp -0.3125 )
Enclosed my QVW file.
Paul
Try this:
=NUM(
(count(distinct(if(inv>'800000' and inv<'899999' and CYTD,inv)))
-
count(distinct(if(inv>'800000' and inv<'899999' and LY_YTD_Flag,inv))))
/
count(distinct(if(inv>'800000' and inv<'899999' and LY_YTD_Flag,inv))), '##.0%')
!Hi Paul,
Try it
Regards
Miguel del Valle
Hi All
Thank you both Sunny & Miguel help , now work fine.
Paul