Share
Report
92Hi Everyone!
I have this formula that sums up a column in my table dependent on some filters:
Text(Sum(Filter(FY25S,And(Or(IsBlank(ComboBox1.SelectedItems),IsEmpty(ComboBox1.SelectedItems), Market in ComboBox1.SelectedItems),Or(IsBlank(ComboBox1_1.SelectedItems),IsEmpty(ComboBox1_1.SelectedItems),Retailer in ComboBox1_1.SelectedItems),Or(IsBlank(ComboBox1_2.SelectedItems),IsEmpty(ComboBox1_2.SelectedItems),Campaign in ComboBox1_2.SelectedItems))),'Trade Q1'), "0","en-GB")
This worked perfectly but since i have changed the table to FY25S it no longer works and highlights that a number is expected where highlighted red. My assumption is that It thinks Market is coming from my previous table 'Tracks' both columns are called the same in both tables.
Is there any way I can fix this?
Thanks!
All responses (
Answers (
