Set Analysis with WeekNo and Positive Margin

[MK_QSL]

Want to show sale for last 10 weeks….

Where %Profit should be > 0%.

Document Date is the date...

Please help....

[MK_QSL]

What is wrong in below expression?

=SUM({$<Profit = {">0%"}, Week = {"<=$(Week(Today()-7")} >}InvoiceAmount)

[#3]

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)

[MK_QSL]

I am receiving an error....!!!

[sushil353]

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