Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
The challenge is to have it sum Volume even though its SelectionType column is different. Here's a representation of the table as the it is:
SelectionType | Description | Revenue | Vol | Unit Price |
NA | Gross Unit Price | 100.0000 | 90.000 | 10.00 |
SimpleDisc | Unit Price | 90.000 | 'Not showing' | 'Therefore, no unit price' |
NA | Vol | 90.000 |
There's a variable governing SelectionType through button and its name is vSelection.
The first part (green) gives me the Revenue, but when trying to get the Volume sum, it gives me null.
I've tried the second portion below in blue, ignoring SelectionType filter but it doesn't seem to work:
Sum({<SelectionType= {'$(vSelection)','NA'}>}[Revenue]) / Sum({1<SelectionType= p(SelectionType)>}Vol)
Thank you!
You are trying to ignore selection in SelectionType field or do you want to allow it for Vol?
Hi, @sunny_talwar !
I need Unit Price whose SelectionType is SimplesDisc to consider the Vol, despite its SelectionType is NA.
I thought that having Vol ignore SelectionType would solve it...
May be this?
Sum(TOTAL {1<SelectionType = {'SimplesDisc'}>} Vol)
It doesn't give me a null anymore! 🙂
I believe it's getting everything now and the Unit Price is much lower that it should be. How would I now go about including a filter, considering that there is TOTAL there.
Thank you!