AnsweredAssumed Answered

How many orders last 30 days

Question asked by andresen on May 19, 2016
Latest reply on Jun 20, 2016 by DamianKelly

I have looked in the Advanced Training Series and here in this discussions but can't find an answer. I'm thinking it should not be so hard...

 

In my custom table I made a calculation field that I want to show; How many orders have been made the last 30 days.

 

In order table I have a date field that show the date the order is made.

 

I have tried the Let function and the Case function with no good result.

 

I'm thinking of getting the last 30 days as a variable and use it some how. I'm stuck! Please help me get loose from this swamp.

Outcomes