I have a key figure "Net Price" is an Attribute of one InfoObject "Material Price".
I have created a formula variable with replacement path processing type, Replacement path as "Material Price" with Attribute Value as"Net Price".And also I'm maintaining this Net price based on Week and month.
But,i'm using month as a user entry option in my query. Now, the problem is coz for this variable.
For eg, Lets say I have 5 weeks in a month and Net price for the Week 41/2007 to 43/2007 is "1548" and week 44/2007 to 45/2007 is " 1118.33 ". User want to see the value always from week 45/2007 ie., "1118.33" in the report.
my report is based on the Month, it will always takes the first week ("From value") of the month, so we can see the value as "1548" as price in the report. Even i tried to create a new formula variable should pick up the "To value", but its always picking up the first value.
Is there any way to fix this issue. Please help me out for this issue.