Hi.
I have a report that is grouped by month. (Month_Id)
In every group.month there is a formula which creates a percentage based on some figures in the group.
The report is based on a table that is updated monthly
In the report header i would like to display the latest percentage figure. for the latest month.
i.e. if data is in the db for march then it will display the march %. if not then it will display the february %. etc
I have tried a few and so far have not go anywhere. Can anyone give me any ideas please
thanks
I have a report that is grouped by month. (Month_Id)
In every group.month there is a formula which creates a percentage based on some figures in the group.
The report is based on a table that is updated monthly
In the report header i would like to display the latest percentage figure. for the latest month.
i.e. if data is in the db for march then it will display the march %. if not then it will display the february %. etc
I have tried a few and so far have not go anywhere. Can anyone give me any ideas please
thanks