Scheduled Report

[Jin_Tan]

Hi,

I am trying to set up a schedule report to check my inventory once every 2 week.

I create the report for the entire inventory table. Here are the problems i have encountered:

1. I am unable to fire the report action once ever 2 week. The only choices are daily, weekly, monthly.

2. I am unable to generate report excluding inventory that is no longer available in store(in other words, the inventory that has already finished). As It is written in the condition section that “This formula is not evaluated in the context of a row, so column values are not available.”. Thus, I am unable to use this formula: “[Current Stock]<0” under condition to fire report action.

Is there any way i can solve this 2 problems?

[Aleksi]

#1 - Add a condition rule if this is a correct week you should send it. You could use something like… MOD(WEEKNUM(TODAY()),2)=0
#2 - Create a slice with that [Current Stock]<0 condition and then use that slice for your report.