LVL 3: 4.6.3 Data Hub Model: SYS14 module
Dear Team,
I got stuck in one place while building SYS 14 module, i don't have my old Data Hub model bcz of which i downloaded from training.
1) If it was DH model - then Data? has a simple formula to see whether SKU Filter system module has data and if yes then check if any Product is
their
2) If DH is downloaded from training - it was to use a formula that references the entire timescale of the DAT05 Historic Revenue by Product module to filter for revenue greater than 0.
The entire time scale of DAT05 - FY19 QTR?
Do I need to refer DAT05 Module with rev>0? 'DAT05 Historic Revenue'.Revenue > 0
I tried but I am missing something here. Kindly guide.
Answers
-
Hi @kunal_311 ,
Try using the timesum to aggrregate over entire timescale and then compare it whether it is grater than 0 or not.
0
