cancel
Showing results for 
Search instead for 
Did you mean: 

Formula Variable with Replacement Path - drillup ref.char and still working

Former Member
0 Kudos

Hi all,

I have a requirement, where formula variable (with replacement path) shouldn't work when I remove the reference characteristic from the rows. But this is not the case at the moment

I have 'Brand' and 'Material' in the rows and there is 'Material Indicator' in the columns. This 'Material Indicator' is a formula and there is formula variable in it with the type replacement path.

Reference char is 'Material'; Replace with 'Attribute Value' is selected also. As attribute I am selecting one of the attributes of the 'Material'.

In the report output, I am seeing relevant attribute values when Material is in the rows. But when I remove the Material from the report, I still see the values for this Material Indicator column. But I expect to see blank instead..

Can you please share your comments?

Thanks in advance.

S.P.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

hi,

Irrespective of the drilldown on Material, the fomula variable will be replaced by material value. This is how replacement variable should behave. You might have to change the design. For more inputs, let me know your requirement exactly.

Answers (0)