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?