taxcalculator.aia (165.6 KB)
i did it today but the answers are coming different i think B3,B5,B10 values are not in percentage it should be in percentage thats why result is wrong also decimal is not coming ex:2459 instead of 24.59
please look in the aia file i attached also how can i send excel file to you so can see te actual result
one thing is you have in b15 block put 0.18 will it be 18 or 0.18
In Excel, you can format a column or cell as a percentage.
This has the effect of showing 100 times the fractional value and JOINing a '%' after it to show it is a percentage.
AI2 does not have a native percentage data type or any such formatting capability.
It only stores percentages as the fractions that they really are, like 0.18
I am going to assume your app is working in rupees ()
since you use 18% and 'GST' and are exceptionally polite to us.
From looking at your Designer
your label text lacks sufficient detail to express the units (rupee vs pure number vs percentage of WHAT(PP?)) of the associated text input.
You have 3 text boxes that are in percentages (B3, B5, B10), but you fail to do the required divide by 100 in the value procedures for those numbers.
Here is my take on a fix, with some non-numeric cleanup added as a separate pass over the inputs ...
hello again,
yes sir i am working on rupee (INR)
I have given link below for excel file so you can calculate result yourself also ive done one mistake in Total expenses formula at B18 it will be B12 INSTEAD OF B5+B6+B7+B8+B9+B13+B14+B15 THIS IS WRONG B12+B6+B7+B8+B9+B13+B14+B15 THIS IS RIGHT
OMG! It is working as I wanted and calculations are correct thank you all admins
would ask one last favour I need three solutions
1, when we enter value in textbox and on keyboard when click enter it would go to next box.
2, is there any way that all calculations after putting values updates realtime without clicking calculate button.
3. How to round off result,and I can't align all my textbox and labels straight I used label as space in editor it shows straight but in mobile it crumbles
Not sure about keyboard enter key - you can have a 'submit' button.
Make a Block List of all those Text Boxes, in the same order as they are displayed. When the submit button is tapped, it can set the focus to the next TextBox in the List.
Not a good idea - if you want to do it, the code will have to check which values are already entered and calculate only a semi-result, due to the dependency of the calculations. There is no real advantage in doing that.