Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey Guys,
it's me again. i need your help.
i was building this expression:
=Sum({$<SollWerte18.Bereich={'Soll Kueche'},Geschäftsjahr=,Datum={'$(=date(max(SollWerte18.Datum)'}>}SollWerte18.Data)
-(num((Sum({$<DATUM={'$(=date(max(DATUM)))'},BWA_Bezeichnung={'Wareneinsatz Küche Vorjahr aufgelaufen Prozent'}>}BWA_Wert)),'##,#'))
&' %'
the output is correct, but i can't make it a num format like '##,#'. I tried every scenario for num() but everything i get is an error or a long number.
Any ideas how to solve it?