Display number with rounded decimals but keep more decimals internally for calculation

[gimaumi]

Following issue is occurring:

• Number is used for calculations and stored in a text or label field
• For the calculations I need the full number (with all decimals)
• For the display form I need the number with only two decimals

Already tried some different solutions:

• Round
• Text (if tough this could achieve this, but it does quite the same as rounded)

The only solution I currently see, is to have a display input and an internal (hidden) input but this makes the application way to heavy in the long-term

Thanks in advance for your help and/or ideas

[JR-BejeweledOne]

You mentioned that this is a form?   I know you said it might make your app 'way too heavy' in the long run but if you are using a form, it may be your best option:

• Patch a temporary collection each time a number is entered and update that row in the collection if the number is changed, for each number and display the collection value in the field as the default with the text formula below.  Reference the saved value in the correct collection row to do your calculations since it will be the whole value.
• Add a label to the data card where you need to display the rounded values.   Make the label visible when the form is in View Mode and the DataCardValue visible when the form is in Edit mode.  Use the Data Card value for calculations

Use this text formula to display the rounded values.

Text(Value(15.50),"[$-en-US]##.00")

[gimaumi]

Thanks for your response but the issue is not situated in a form. We are talking about +- 100 basic calculations that could extend to +- 250 so this would be a really hard solution.

We are patching multiple SharePoint data sources at once and working with multiple collections already. To add another collection with all this information, updating all current logic would make it quite hard.

Please feel free to enlighten us or to propose another solution

[JR-BejeweledOne · Accepted solution]

Regardless which option you choose, there is going to be additional logic required.  If you need the number in 2 different formats, one for display and one for calculations, you will have to store the full number somewhere. PowerApps doesn't allow you to create circular references, so trying to set the display of your label/text inputs by referencing other properties of the same control won't work.

Your options for saving this number are:

• A collection (I think this is the one that will require the least additional logic and overhead)
• A variable
• A hidden control

The original question stated: For the display form I need the number with only two decimals.  You haven't indicated when and how these numbers are being patched to the various collections, however reading that leads me to believe that the numbers have already been patched to a collection at the time of display.   If that is the case, you could add a column in the collection(s) solely for the purposes of referencing the number (It wouldn't get patched to any data source).  It would need to be a distinct value that indicates exactly which number it is.  When you patch your collection(s) you would patch the number reference for each number patched.  Then your text inputs could have the default set to the text formula or the full number value conditionally:

Text(Value(LookUp(CollectionName, RefColumn = "RefID").NumberColumn),"[$-en-US]##.00")

Since labels typically display either 'hard coded' information or information from somewhere else, you should be able to use an If or a Switch to determine whether it displays the full number or the rounded number, since the original number would still be available for your calculations.  If that doesn't work, then a variable can be set in the OnChange property of the associated control that the label is referencing.  The variable can then be used in the label's text property.  If this method isn't an option then you are left with variables and hidden controls.   

For the text inputs, if using the collection value isn't an option, and labels (if necessary), you would need to use a 'hidden control'.   Personally I would layer a label and the text input.  Then set the value of the label to the rounded value and then manipulate the visible properties of both to determine when each one is displayed.   If you are wanting to display all the rounded numbers at the same time as a 'display' once the fields are filled out, you could use a single global variable set to true or false.  You would set it to true in the App OnStart or in a control (if you have one) that tells the form it's being edited. Once the form is submitted set the variable to false.   Set the text input's visible property to varDisplay and for the label set the visible property to !varDisplay.  

Otherwise you would need another condition to tell each control when it should be visible. 

[Anonymous]

So, as JR-BejeweledOne mention You shoul store your data in somewhere, if you don't want to put number statically in every text label. Let's consider You will do it manually:

You can use formatting like this Text(4.333,"#.#") becomes 4.3

Otherwise, when You use dynamically input You can state your source in Text where 4.333 placed.