Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Convert measure to %...

Hi Experts

 

how would you convert the following formula to a percentage...

 

= CONCATENATE("("&DIVIDE([F2FManagementReferrals],[TotalManagementReferrals],0),")")

 

  • Anonymous

     

    May be...

    Not Sure

     

    =
    CONCATENATE (
        "("
            & ROUND (
                DIVIDE ( [F2FManagementReferrals], [TotalManagementReferrals], 0 ) * 100,
                2
            ),
        "%)"
    )

2 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion

    Anonymous

     

    May be...

    Not Sure

     

    =
    CONCATENATE (
        "("
            & ROUND (
                DIVIDE ( [F2FManagementReferrals], [TotalManagementReferrals], 0 ) * 100,
                2
            ),
        "%)"
    )
    • Anonymous's avatar
      Anonymous
      Not applicable

      zUBIAR

       

      many thanks, i adjusted for dplaces. excellent