Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello:
I'm sure I'm missing something simple in the following expression, but I would appreciate another set of eyes taking a look to see what may be wrong.
The expression editor simply says "Error in expression" and puts a red squiggly line under the last parentheses. All the parentheses seem to match up.
As always, any and all help is appreciated. Thanks in advance.
Try this
Num(Count({<
[Service Ordered] *= {'Virtual Server Infrastructure (VSI)', 'VSI ICP2'},
Forecast_Product_Base_C *= {'VSI Bronze Base'},
[Approval Completed Quarter] *= {'2019-Q1'}>}
[Host Name]), '#,##0')
Try this
Num(Count({<
[Service Ordered] *= {'Virtual Server Infrastructure (VSI)', 'VSI ICP2'},
Forecast_Product_Base_C *= {'VSI Bronze Base'},
[Approval Completed Quarter] *= {'2019-Q1'}>}
[Host Name]), '#,##0')
Hello Sunny:
Thanks for the quick reply. I appreciate it. Yes, you're solution works. So, would I be right to assume the If isn't needed because I'm being specific about what to count?
If Product is your dimension, you wouldn't need if statement....
Product is the dimension label. Forecast_Product_Base_C is the actual dimension name for that column. If I don't need the IF statement, what would the set analysis look like?
I am not sure I understand your data... would you be able to share some raw data and the output you expect from it in an Excel file?
I'm having a problem with my data model at the moment. Once I get that fixed, I'll provide some sample data and sample output. I appreciate your patience.
Hello Sunny:
I'm still having some data problems, but your initial answer was correct and I will mark it as such. I'll start another thread if needed for my newest problem. Thank you for your assistance. It's appreciated.