Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm struggling with conditional logic that won't seem to work.
I have a field Value and I want to calculate the sum of teh field based upon a value in another field Category.
I have tried IF logic like this "if( Category= 'Income', (sum(Value) ))"
I have tried Set analysis like this "=Sum({$<Category={$(="Income")}>}Value)"
Neither works. Here is a screenshot of a table showing that there are data in both fields.
I hope someone can help me - I'm sure it's something really basic.
Many thanks in advance
Hi,
Try :
Sum({<Category={'Income'}>} Value)
Aurélien
Try this:
=Sum({$<Category={'Income'}>}Value)
Many thanks to you both. Sunny's answer worked immediately.