% sign with a value.

Saad
Saad Customer
10 Comments
in Platform

Hi, I am creating a report and I am using expression in rules to calculate Gross Margin %. It is calculated correctly but I cannot put % sign with the number. Is there a way of doing that.


Accepted Answer

  • Daniel Borghs
    Daniel Borghs Employee
    Fourth Anniversary 5 Likes Level 100: Foundations of Building in Board Level 200: Building A Planning Solution in Board
    edited May 2023 Answer ✓

    Hi Saad, in order for the Entity Design Template to be applied, you need to select it in the Dataview Properties on right hand side when clicking on the Dataview in Edit Mode:

    image.png

    The rule does not need to be changed. The % is only a visual element,

    Regards, Daniel

Answers

  • Samir Jones
    Samir Jones Active Partner, Community Captain
    100 Comments Third Anniversary 100 Up Votes 25 Likes

    Hello,

    In the screen:

    1. Select the Dataview.
    2. Go to Block format.
    image.png

    In Block format, select the cells for the block that will have the % sign.

    image.png

    Type the sign/symbol you want to use. If you want to add decimals, you can also do it here.

    I usually put a space before the % sign, but it's up to you (or the customer) what you prefer.

    After you are done, remember to press Save.

    image.png

    Good luck!

  • Saad
    Saad Customer
    10 Comments

    Thanks for your help Samir. The above option apply the sign to all the cells whereas I want % sign to be applied to just one cell. e,g

    Revenue $1,000

    Expenses $500

    Gross Margin 5%

  • Navan Mehra
    Navan Mehra Employee
    Third Anniversary 10 Comments 5 Up Votes Level 100: Foundations of Building in Board

    The method which Samir shared applies to the entire block. If you are displaying your data in rows,use the Format option under Data Model. Define a format on your entity and put a %sign against the Gross Margin member.

  • Saad
    Saad Customer
    10 Comments

    Thanks Navan. Do I need to amend the rule as well which calculates Gross Margin percentage

  • Saad
    Saad Customer
    10 Comments

    Its not working Navan

  • Samir Jones
    Samir Jones Active Partner, Community Captain
    100 Comments Third Anniversary 100 Up Votes 25 Likes
    https://community.board.com/discussion/comment/14614#Comment_14614

    Sorry, I read your questions too quickly. :-)
    I agree with Navan, to use the Format option.

    I hope you get it to work.

Categories