Skip to Content
0
Former Member
Dec 13, 2013 at 10:36 AM

Create SELECT statement formulas from SAP BW Query

23 Views

Hi All,

Im currently creating a crystal report based on a sap BI query. Some of the key figures must be created using the following condition:

=NUM1, where PERIOD= 0CALYEAR||01 and PERIOD2= 0CALYEAR||01

NUM1 is the key figure while period and period2 will have the value of the selection year with concatenated month (e.g. 01, 02, 03).

How can I do this in crystal report formula?

Thanks,

Louis