Hi @Spandan98, what I usually do when I need to treat blank as false so I can properly filter for it, is using EXCLUDE of all true values. You could create a new metric FLTR Brands w/o switch Price
and add the formula TRUETADD CONSTANT: Brand]aEXCLUDE: INP_switch_Price]
. This should give you TRUE for all combinations except where your switch price metric is true. Then, to filter for those brands in a View, you will need to create a table, add your INP_ForecastPrice_Manual to it as well as your new FLTR metric. In the View, add a filter to keep only brands where that FLTR metric is TRUE and then hide the FLTR metric.
Hi @Spandan98, depending on the requirement, I believe an option could be to create multiple metrics for this.
The first one (MetricA) will capture manual inputs only for the unmarked brands. You can filter your view to show the unmarked brands only, so the users will be able to enter data for the unmarked brands. For this you’ll need a filter metric just as @oliverlee oliverlee suggested.
Then, you’ll need a second metric (MetricB) that will automatically calculate the values of the marked brands. You’ll want to use the tFILTER: INP_Switch_Price=TRUE] in your formula, so it runs the calculation only on those brands that are set to true. You would need to filter the view too to display the marked brands only, using a filter metric.
The final step would be combining your two previous metrics as MetricAcEXCLUDE: INP_Switch_Price=TRUE] + MetricB