How to calculate difference from previous date, for each category?

Question

Hi,

I am trying to calculate difference from previous date of a variable (daily change and difference from first date) for each category in my workflow.

There are three categories in my data, Market, Delivery Month and Portfolio.

For this calculation I used The Multi-Row Formula tool (see attached file), but my calculation is wrong, can you help me on this?

Thanks,

Price Change.yxmd

rfoster7 · Answer

I wouldn't use the multi-row formula for that. I mean you could do it, but if I wanted "max price, grouped by market and delivery month", I'd use a group by tool, then append it back to the dataset like so:

But if you absolutely needed to do it with a multi row tool you probably could but I wouldn't want to figure it out

Mehrheyr · Answer

Hi @rfoster7 
Thank you, I check is on my real data and that was perfect.
I have one more question, If I want to get max value or price for each date and market (same as price change) how can I do it with Multi-Row formula?
Thanks,

Mehrheyr · Answer

Perfect,
Thank you for your help
I'll check it with my real data.
Many thanks,

Mehrdad