Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Below expression work fine , it only round up 0.5 when value more then 10.
if ( column(1) <10 ,
num( ( column(1)) , '#.##') ,
num( Ceil( column(1),0.5) , '#.#') )
Now i like to add one more condition , if user select :-
Currency_P=SG value < 10 don't round other wise round up to 0.5
Currency_P=INDO value < 300 don't round other wise round up to 0.5
I assume the expression should be as following :-
if Currency_P='SG',
if ( column(1) <10 ,
num( ( column(1)) , '#.##') ,
num( Ceil( column(1),0.5) , '#.#') )
if Currency_P='INDO',
if ( column(1) <300 ,
num( ( column(1)) , '#.##') ,
num( Ceil( column(1),0.5) , '#.#') )
))
But it does not work . Hope some one can advise me.
Paul
enclosed my QV doc