Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
If I want to change "Faktureret" from being different from "0", to being between to values. For example between 0.01 and 100000 how do i do that?
Thanks for the help 🙂
Sum ( {< Date_num_afsl = {"<=$(=num(floor(MonthEnd(Max(Dato_NUM_Tid))))), >=$(=num(monthstart(Min(Dato_NUM_Tid))))"}, [År Tid] =, [Måned Tid] =, [År (Regnskab) Tid]=, IGVA_DATO =, //Faktureret ={"<>0"} Projektnr = {"*"}-{''}, >} Faktureret)
Temporarily ignoring all your other rules, I think you may just be looking for this:
=sum({<Faktureret={">=0.01<=100000"}>} Faktureret)