QTD < YTD <MTD view in the form

deveshsharma
New Contributor

We are trying to input data on monthly basis for forecast and actual. As in next step if we want to see QTD view which should be M1+M2+M3 , but its not working. 

how does this QTD and MTD workflow works in the form ??

In historical data its working perfectly fine.

4 REPLIES 4

Hweeli
Moderator
Moderator

What is the Account Type?  BS Account Type will not be M1+M2+M3.

hello ,

thanks for your reply , i am asking about Income and expense account.

sorry for not mentioning it clearly

Hi,

if it's PL accounts you should have the following, QTD is the quarter to date.

Hweeli_0-1661153953121.png

 

jordielane
New Contributor III

Is there a way to get QTD data for balance sheet accounts? 

 

Nevermind I figured it out. For anyone else wondering the same thing - set "Switch Type" on the flow member to True for balance sheet accounts.