Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a query the first one works but the second one does not.
Works-
if(BOB = 'A',
(sum({$<BOB_age={'$(=DATE(vC))'},age={'>=16 <=25'} >} aging_A) *100),
(sum({$<BOB_age={'$(=DATE(vC))'},age={'>=16 <=25'} >} aging_B) *100))
Does not work:
sum({$<BOB-={'A'},BOB_age={'$(=DATE(vC))'},age={'>=16 <=25'} >} aging_A) *100
+sum({$<BOB={'A'},BOB_age={'$(=DATE(vC))'},age={'>=16 <=25'} >} aging_B) *100
Why?
Thanks.
Did you do it opposite?
Sum({$<BOB ={'A'},BOB_age={'$(=DATE(vC))'},age={'>=16 <=25'} >} aging_A) *100
+Sum({$<BOB -={'A'},BOB_age={'$(=DATE(vC))'},age={'>=16 <=25'} >} aging_B) *100
Further I would try to use RangeSum() function here to sum them:
RangeSum(Sum({$<BOB = {'A'}, BOB_age = {'$(=DATE(vC))'}, age = {'>=16 <=25'} >} aging_A) * 100, Sum({$<BOB -={'A'}, BOB_age = {'$(=DATE(vC))'}, age = {'>=16 <=25'}>} aging_B) * 100)