Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to output the balance amount only if there is only one currency in the sample. I found a way to output this condition separately for a particular currency:
NUM(Sum({$<[currency]={'810'}>} [currency_balance]), '# ##0,00')
Now I need to make sum output only when filtering is for one currency.
@KimFerguson Not sure what is your requirement. If I understand correctly, if the user selects any Currency in the Filter Pane, your Sum value should change accordingly? Is my understanding right?