Fernando L Sousa 27.Jun.12 11:37 AM a Web browser Domino Designer All Releases All Platforms
I have a form with 12 fields that represent a Rating for every month of a year (Jan_Rating, Feb_Rating....), these fields are filled once a month, in the beginning of the current month.
I need a field in that document that shows the current rating average at that point in time...
Here's a scenario:
If the user goes in the form and fills January with a rating of 10 then my rating average should show 10, regardless of all the other months being 0. In February the user goes in again and gives a rating of 20 then my average should be (10+20) / 2 ... and so on.
I know I should create some type of counter field that stores how many months were rating so far but I can't find a way of doing it.
I created a field called 'counter' (computed) and I have an @If statement that looks like this:
@IF(Jan_Rating <> 0 ; 1 ; 0)
@IF(Feb_Rating <> 0 ; 2 ; 0)
@IF(Mar_Rating <> 0 ; 3 ;0)
but I think I'm way of course here....
I think this is a simple process but I just can't find the way...
Thank you for all your help!