Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
As per the requirement, i need to write the condition combining 'and ' and 'OR' condition in the set analysis.
Please let me know ASAP.
Category like 'SYSTEM %'
or Categorylike 'HARDWARE%' in the single condition .
Thanks in advance,
Smitha
Hi,
Try below
=sum({<Category = {'SYSTEM*','HARDWARE*'>}Amount)
Regards
ASHFAQ
Hi Smitha,
Please try like this:
sum({<Category={'SYSTEM %'},Category={'HARDWARE %'}>}amount)
or if(Category='SYSTEM %' or Category='HARDWARE %', sum(amount))
if(Category='SYSTEM %' and Category='HARDWARE %', sum(amount))
Hi Smitha,
Try this
=sum({<Category={'SYSTEM*'}> + <Category={'HARDWARE'}>} Amount)
Hope it will work for you.
-- Regards,
VIshal Waghole