Skip to Content
Former Member
Dec 14, 2009 at 07:09 AM

Simple Question in Query Designer


Hi Guys,

I have requirement and I need to know how to do it in the query designer.

I have two key figures called deferred revenue and revenue recognized. If the deferred revenue KF is not initial then I have to display the fiscal period under the deferred period and if the revenue recognized amount is not initial then display the fiscal period under the revenue recognized period.

For example:

cocode Bus area Profit center def period revenue period defered amount rev recognized amount

100 1000 2000 001/2010 1000.00 0.00

100 2000 n 2500 002/2010 0.00 5000.00

The fiscal period has to be dislayed like the above based on the the 2 KF values.

Thanks for your help in advance.