Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
4 years ago

How to modify my expression to display 3% ?

Hi All, I have below expression working fine :- _YTD_NPM = DIVIDE([_YTD_NP_],[_YTD_REV_N]*1)  it return 0.03 , may i know how to make it 3% ?   i try modify the expression like below :- ...
Need Help
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
4 years ago

admin11 

pls try MAX the VAR column , not LY.

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
4 years ago

ryan_mayu 

Very sorry I don't understand, can you pls explain in a bit more detail. 
paul

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    4 years ago

    admin11 

    pls see the highlight part. It's differrent from the screenshot you provided.

     

    IF(MAX(PNL_VAR)="7_NPM", DIVIDE([_YTD_NP_],[_YTD_REV_N])*100&"%",DIVIDE([_YTD_NP_],[_YTD_REV_N]*1))