Can we divide a column's data with another column's previous day data ?

Hi Anshul,

Can you elaborate on how this would work? Typically dates are not stored in number format so are difficult to do math on top of.

The best route for this is to use our pre-defined functions or freehand such as DATEDIFF to first make this date a real number which you can then do math on. (eg: days since ___).

Regards,

Nathan

Hi Nathan,

Just to elaborate I have two columns A and B which are coming from DB by date (like A contains some data for whole month and B contains some other data for whole month). Now I want a third column C which contains division of A by B's previous day data (For ex: C equals A data of 11th October/ B data of 10th October)

Please suggest me if this can be done through Yellowfin.

Thanks

Anshul

Hi Anshul,

Typically the best way to do this is to create an append sub-query joining on whatever these two columns have in common.

In the first sub-query, filter the data down to todays date, and in the second, filter it down to be yesterdays date.

You can also do this with calculated fields.

Once you have columns representing each day, you can just do basic division using a third calculated field.

Let me know if this makes sense.

Regards,

Nathan

I am going to set this ticket to closed for now, but if there is anything else I can do to help here, please just let me know and the case will be re-opened!

Regards,

Nathan