GetPromptValue As Parameter For Dashboard

Chai Chang

I created a BQL measure that will default to $0 if the user wants to exclude negative dollar amount from my Report or include it. Below is my syntax.

IIF(INTEGER(GetPromptValue('NegativeSellingPriceZero', '0')) = 1 AND [Trailer Invoice Date: Trailer Net Selling Price] < 0, 0, [Trailer Invoice Date: Trailer Net Selling Price] )

It shows up on the report since default is 0, and will show negative dollar. In my Dashboard, I created a filter and use "NegativeSellingPriceZero" and use as parameter. I added custom value Yes = 1, but this does not work at all. Is there something wrong with my BQL syntax or am I not creating the filter correctly?

Diane McElhiney

First, remove the INTEGER() casting. And to debug whether the GetPromptValue is returning the correct value or whether it is the measure, remove the measure (in the 'then' IIF portion, hard-code a value). I've tested with the Filter construct provided and an IIF statement with just GetPromptValue and the result is as expected.