Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Could you help me showing the negative amount in this expression?
If(Type = 'D', Sum({<FactType = {'T'}>}Amount)
, If(Type = 'C' AND GL = '1001', 'Show Negative Amount Only'
, Sum({<FactType = {'T'}>}Amount)))
Thank you. Much appreciated
@AH are you looking for ?
=sum({<Amount={"<0"},FactType = {'T'}>}Amount)
for example :
@AH are you looking for ?
=sum({<Amount={"<0"},FactType = {'T'}>}Amount)
for example :
That is the correct answer. Thanks for the help Taoufiq!
Much appreciated