Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good evening everyone,
using the following set analysis expression i'm retriving the sum of report hours for request 69,70,71....268.
But i select one request number, for ex 71, the table does not reflect the selections and continue to show the sum() al all request number of the set analysis.... how to fix ?
Sum({$<[Request Number]={69,70,71,72,73,74,75,76,176,197,255,264,268}>} [Report Hours])
Try it with:
Sum({$<[Request Number]*={69,70,71,72,73,74,75,76,176,197,255,264,268}>} [Report Hours])
- Marcus
Hi,
You can create a new field like [Request Type] and use it in set analysis.
for example:
MyTable:
LOAD *
INLINE [
Request Number, type
69, a
70, a
71, b
72, b
];
Sum({$<type={'A'}>} [Request Hours])
Aurélien
Try it with:
Sum({$<[Request Number]*={69,70,71,72,73,74,75,76,176,197,255,264,268}>} [Report Hours])
- Marcus