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.
try
Sum({$< Fruits= {'Red','Green'}, Fruits-={'Apple'} >}Sweet)
or
If(Fruits = 'Red',
Sum({$< Fruits= {'Red','Green'}, Fruits-={'Apple'} >}Sweet)
)
hi,
you can exclude the apple like this below:
sum({<fruit_color = {'Red'},fruit_type -= {'Apple'}>}sweet)
You can't define same fields 2 times within Set expression.
Anyway, arwinpabz can you describe exactly what you are doing? You want to exclude the value or field ignore?
yes i missed it it might be other field but he didnt mentioned so i thought he will change
This is my real code.. I'd like to ignore the selection of months. But it's not working.
If(vCurrency_1 = 'CND',
Sum({$< Currency = {'CND'}, Month>}Budget),
Sum({$< Currency = {'USD'}, Month>}Budget)
)
Try this
If(vCurrency_1 = 'CND',
Sum({$< Currency = {'CND'}, Month=>}Budget),
Sum({$< Currency = {'USD'}, Month=>}Budget)
)
Already did that but it not working as well..
Could you share your app with sample data?
Hi,
Can you share your app