Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have expression like this
sum({code={'654','2','131'}>} Amount)
+
(fabs(sum(distinct{<category={'1005'},code={'2'}>} Amount}
-
fabs(sum(distinct{<category={'1005'},code{'45'}>} Amount )))
+
sum(distinct{<category={'12','34','56','78','90'},code={'56'}>} Amount )
now the second expression which is
(fabs(sum(distinct{<category={'1005'},code={'2'}>} Amount}
-
fabs(sum(distinct{<category={'1005'},code{'45'}>} Amount )))
i want to modify this only in 1 line like this look category is same but code is different so is this possible to subtract like this ?
(fabs(sum(distinct{<category={'1005'},code={'2'} - code ={'45'}>} Amount}
any help
This should work?
(fabs(sum(distinct{<category= {1005,2} - {45}>} Amount}
no.
(fabs(sum(distinct{<category= {1005,2} - {45}>} Amount}
here category is only 1005 and transaction code are 2 and 45 .. so i want minus between codes not categories
Ok, now I understand. A one-line expression like you proposed is not working since set analysis will exclude data not deduct values. So you must write 2 expressions.