Skip to Content
0

How to create quarter variable...?

Nov 10, 2016 at 10:17 AM

43

avatar image

Hey Experts,

I am stuck in my webi report. Please help me.

My requirement is I have MONTHS variable out of which I have created Quarter variable which I achieved through IF formula. Now in table I am using measure called Avg(Qty) in Months column value is coming proper but same measure if I am using in Quarter variable I am not getting expected value, though its showing but not logically.

screenshot is placed below:

Quarter is being considered by Fiscal Year.

Even I tried using formula : Avg(Qty)ForEach([Months] ) or other diimensions too.like Zone , RO, Div, Fiscal Year.

screenshot.png (10.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Sushil Padhye Nov 10, 2016 at 11:46 AM
0

Hello Ankit,

can you please explain issue in detail with some more detailed example.

This will help me provide solution :)

Regards,

Sushil Padhye

Share
10 |10000 characters needed characters left characters exceeded
Venkatesh Katta Nov 16, 2016 at 05:15 PM
0

Hi Ankit

Try to create Quarter with the help of "group" feature as mentioned in below link and perform the operations, check if it helps.

https://archive.sap.com/documents/docs/DOC-49932

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/f0af8996-333f-3110-55a1-ec9774bd3b36&overridelayout=true

This feature is introduced in SAP BO 4.1 sp2

Regards

Venkatesh

Share
10 |10000 characters needed characters left characters exceeded