Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Would like to create a set analysis that would ignore a selection, but this won't work. Any idea what the problem is?
If(Fruits = 'Red',
Sum({$< Fruits = {'Red'}, Apple >}Sweet),
Sum({$< Fruits = {'Green'}, Apple >}Sweet)
)
I'd like to ignore the field of Apple.
Can't share the app as it contains confidential data.. Is there any form of set analysis that would give me the same result?
Apple is fieldName or value in table?
If it is value then it come under which field ?
If you want to show sum of sweet where Fruit is Red or Green.
then just use
sum({<Fruits={'Red','Green'}>}Sweet)
Regards,
First check value of your variable vCurrency_1 that, are you getting selected value (CND or USD) in it?
If(vCurrency_1 = 'CND',
Sum({<Currency = {'CND'},Month>}Budget),
Sum({<Currency = {'USD'},Month>}Budget)
)
It's selected to CND.. All were correct but I just want to disregard the month selection..
How do you define vCurrency_1? is this an expression? Are you ignoring selection in Month field for the expression behind vCurrency_1?
Its working fine at my end
check this if you can find it useful
Can you please provide expression that you have wrote for vCurrency_1
If(vCurrency_1 = 'CND',
Sum({1<Currency = {'CND'},Month>}Budget),
Sum({1<Currency = {'USD'},Month>}Budget)
)
Its just vCurrency_1 = CND