If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Combining two extract formulas

Started by gatorfe, 09 Oct 2007 02:45:18 PM

Previous topic - Next topic

gatorfe

I have a report that has two extract formulas.  The first one is extract(MONTH,[Invoice Date]) and the second one is extract(YEAR,[Ship Date]).  They work great.  What I want to do now is combine them so I get the result of 10/2007.  Any suggestions on what the syntax should be to accomplish this?  Thanks in advance for any suggestions.

MFGF

Hi,

If you just need this value displaying (rather than for filtering or use in further calculations etc), then you don't need to combine them.  Unlock your report structure and drag your month calculation, a text item containing '/' and your year calculation all into the same cell.

Regards,

MF.
Meep!