103 Posts
7 years ago
1
Topic
Hi Friends,
Greetings!
I am trying to get the percentage of a field's value in another field (in site form) like this:
1. Obtained Marks (text field) to be filled by the user like 280,
2. percentage (text field) to be calculated by computation rule ie. (a/700) * 100
[where a is Obtained Marks field]
it is showing perfectly 40
but saving 4056.00 in database instead of 40 or 40.00
and in list view it is showing 4056.00
I tried with all format options like auto/ ceil/ floor/ round/ fixed (2)
Please suggest me the correct way to achieve the solution.
Best Regards
4229 Posts
7 years ago
0
Level 1
Sounds like a mismatch between a display format and a database format - poin gets fitlered out somehwere