Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all!,
I got this straight table and this list box...
and i want to exclude in the table the values that are selected i.e. if Commit and/or CommitBook or Ship were selected then the table will look like this:
PD: Data type its a dimension.
Any idea?
Just give this a shot
Difference % - Num(RangeMax(1 - Sum({<TimeStamp={'Old'}, [Data Type] = e([Data Type])>}Amount) / Sum({<TimeStamp={'New'}, [Data Type] = e([Data Type])>}Amount), 0), '#,###.#0%')
OLD - Sum({<TimeStamp={'Old'}, [Data Type] = e([Data Type])>}Amount)
NEW - Sum({<TimeStamp={'New'}, [Data Type] = e([Data Type])>}Amount)
or this
Difference % - If(GetSelectedCount([Data Type]) = 0, Num(RangeMax(1 - Sum({<TimeStamp={'Old'}>}Amount) / Sum({<TimeStamp={'New'}>}Amount), 0), '#,###.#0%'), Num(RangeMax(1 - Sum({<TimeStamp={'Old'}, [Data Type] = e([Data Type])>}Amount) / Sum({<TimeStamp={'New'}, [Data Type] = e([Data Type])>}Amount), 0), '#,###.#0%'))
OLD - If(GetSelectedCount([Data Type]) = 0, Sum({<TimeStamp={'Old'}>}Amount), Sum({<TimeStamp={'Old'}, [Data Type] = e([Data Type])>}Amount))
NEW - If(GetSelectedCount([Data Type]) = 0, Sum({<TimeStamp={'New'}>}Amount), Sum({<TimeStamp={'New'}, [Data Type] = e([Data Type])>}Amount))
Thanks a lot Sunny! it work with the second choice but now i got this other problem i didint mention it but i have 2 list box but one is to filter by and the other is to exclude!, but the solution you gave me affects both. is there a way to choose wich listbox will be affected by the solution ?
the information is this:
Filter by:
Field: Data Type
ID objct: LB14
To exclude:
Field: Data Type
ID objct: LB28
Does both the list boxes use the same underlying field? If they do... then this won't work... instead create a new field with the same data in the script
Load [Data Type] as [Data Type],
[Data Type] as DataTypeInclude
FROM ...
now when you select DataTypeInclude... it should work fine for you