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.
Hello Ankit,
can you please explain issue in detail with some more detailed example.
This will help me provide solution :)
Regards,
Sushil Padhye
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
This feature is introduced in SAP BO 4.1 sp2
Regards
Venkatesh