This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Could anybody please tell me why only July month was selected? I meant to select current and Previous, Today is Aug 12, so I shall have Aug and July month but I got "2019-July" only...so anything wrong with the formula? Thanks!
Multi-Field formula tool lets you change multiple fields at the same time. It doesn't calculate based on 2 fields.
Your best bet, to calculate the difference, would be to transpose and summarize, as @Thableaus mentioned. That way, you can work dynamically, no matter the months. In a formula tool, you'd have to keep changing things.
Here's a workflow that does that. You may need to change the ultimate sort order, and which value gets the negative, to get your particular logic in.
Basically, convert the month heading into a date, and then sort on that. Turn the later date into a negative number. Use the summarize with Sum to find the difference.