Forum Discussion

Muffin92's avatar
Muffin92
New Member
4 years ago

Generating monthly table with diminishing Object values on hardcoded predefined values

Hello all,    My data contains alot of different object with yearly or monthly "contracts". These contracts represent the values of object on specific dates and whether the value deminishes on a pe...
Need Help
Show and Tell
Tips and Tricks
AntonioHR's avatar
AntonioHR
Icon for Helper I rankHelper I
4 years ago

Hello Muffin92,

I think you could make a new table just with OBJECT and MIN(DATE) so you have the starting date. 

Then in your main table add a column which will use DATEDIFF(DATE, DATE(NEWTABLE)) and an IF(type contract) to get the value