103 Posts
shubhaanshu
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

Get a VIP membership
4229 Posts
Kadministrator
7 years ago
0
Level 1

Sounds like a mismatch between a display format and a database format - poin gets fitlered out somehwere 

Get a Book for SEBLOD