Page 68 - modular4.0
P. 68

Chapter Profile

                                                                             6  Select the Input
                                                                            Message tab.


                                                                             7  Type Data Validation
                                                                            in the Title textbox.


                                                                             8  Type Number should be greater
                                                                            or equal to 0 and less than or equal
                                                                            to 100 in the Input Message text area.













                          9   Select  the  Error
                          Alert  tab  and  type  the
                          error  message  in  the
                          Error message textbox.                                                 10 Click on the
                                                                                                 OK button.


                  Now, if you enter the number which is not in specified range, you will get an error message as shown:




























                         USING SUBTOTAL COMMAND


                  The  Subtotal  command  allows  you  to  calculate  group-wise  sum.  It  also  calculates  the  grand
                  total  at  the  end.  Before  using  the  Subtotal  command,  data  must  be  sorted  in  ascending  or
                  descending order.






                66   Modular (Ver. 4.0)-VII
   63   64   65   66   67   68   69   70   71   72   73