presentation varaiable is not working in edit formula in obiee

Question

hi,

I have written one formula in the edit formula say for ex we have sales measure and there we  need to filter the data using column =@{scenario}{actual} but, when I apply  the presentation variable in edit formual its not working anymore whereas if I apply the formula  as filter( sales using column name ='actual') then report is working fine. please  help me oout on these why the presentation variable is not working in edit formula.

[Deleted User] · Answer

I didn't take it as criticism Robert. Just wanted to "+1" your pertinent statement since it is THE thing to go wrong there.

Robert Angel · Answer

The comment was not directed at you, I just wanted to point out to the asker that the syntax is dependent on the data type.

No criticism intended or implied of your good self or your most detailed and salient response!

:-)

[Deleted User] · Answer

I immediately thought the same thing but just wanted to prove the whole shebang