Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
i have a problem with calculation with condition.
i have a chart that in one column i want him to calculate all time WITHDRAWS no matter what the dates i choose.
the problem is that i have condition to this dimension:(exp)
sum({$<WD_GROUP={'Approved Client Withdraw'}>}WITHDRAWS)
usually when i want to do this i write this format:
sum({<YYYY=,MM=,DD=>} WITHDRAWS)
but when there is condition this action is not working.
i tried to write this but without success:(exp)
sum({$<WD_GROUP={'Approved Client Withdraw'}>}WITHDRAWS) and sum({<YYYY=,MM=,DD=>} WITHDRAWS)
does anyone have idea?
thank you
eran
Have you tried
sum({$<WD_GROUP={'Approved Client Withdraw'}, YYYY=,MM=,DD= >} WITHDRAWS)
?
Have you tried
sum({$<WD_GROUP={'Approved Client Withdraw'}, YYYY=,MM=,DD= >} WITHDRAWS)
?
the only thing i didnt think about.
thank you