Hi I am using a formula to calculate number of days remaining(the user sets number of working days and then makes entry for each day), this formula is working well, however when i am using this formula in a bigger formula it is not working. so i have to show target remaining(target is set by user and when actuals are set, the remainder target is calculated) in one output and number of working days remaining in another output, these are working fine, but in the third output when i combine these formulas to divide the first one by the second the output result does not correctly calculate the second formula and calculates the second formula without deducting the number of days used. please help
Screenshots plz but also go to app settings, Version tab, enable experimental parenthesis so you can do order of operations
1 Like
many thanks, however this hasnt solved the issue since i have no control over the placement of the parenthesis - please see screenshot below of the formula - let me know if you would require the grouped by formula breakdown
so i have gone ahead and created two inputs where i have put each individual formula and then shown a text to display the output as in the screenshot below and it calculates corectly - would this hurt my app optimization?
You should be fine with the two input methods if it is working for you. The parenthesis are a little weird to work with, really it places the parenthesis for you and you have to click “More” to put your values in different spots.
This topic was automatically closed after 70 days. New replies are no longer allowed.