Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Want to show sale for last 10 weeks….
Where %Profit should be > 0%.
Document Date is the date...
Please help....
What is wrong in below expression?
=SUM({$<Profit = {">0%"}, Week = {"<=$(Week(Today()-7")} >}InvoiceAmount)
Is the field Profit really with a %-sign? Isn't that only a number format?
So maby
=SUM({$<Profit = {">0"}, Week = {"<=$(Week(Today()-7")} >}InvoiceAmount)
I am receiving an error....!!!
Hi,
What error you are getting?
try the below expression if you are having profit in real number format..
=SUM({$<Profit -= {0}, Week = {"<=$(Week(Today()-7")} >}InvoiceAmount)
HTH
Sushil