Forum Discussion

GokilaRaviraj's avatar
GokilaRaviraj
Helper II
1 year ago

Calculations based on other 2 datasets

Hi, I have 2 input tables shown below CFY refers to Current FinYear and NFY refers to Next Finyear Total Income Company OctCFY NovCfy DecCFY JanNfy Febnfy Marnfy Aprnfy maynfy junnfy ...
Need Help
Tips and Tricks
GokilaRaviraj's avatar
GokilaRaviraj
Helper II
1 year ago

Hi Anonymous 

 

Now I changed my 2 input tables with months from JanCFY to DecNFY.

In the output table, Value is not showing up for FebCFY column alone. All other columns have values as per the measure.

 

Do you have any idea on this ?

GokilaRaviraj's avatar
GokilaRaviraj
Helper II
1 year ago

Hi Anonymous 

 

I have an another doubt here, This calculation has to be done only when current month is Jan. So i have put a condition like this in the measure, 

IF(FORMAT(TODAY(), "MMMM") ="January", Do the calculation. But in else part, I need to just carry out the same value which was calculated on January. It should not again calculate anything, since my input tables will not have jan value to calculate May value.
 
Is this can be done ?
  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi GokilaRaviraj 

    There is no value in February because there is no value in the previous quarter based on February. Do you mean that February returns the value calculated in January? Then there is another question. If the current month is January, the calculation you described above is performed, and then the value calculated in January is returned. Do you need to perform the calculation performed in the second month of each subsequent quarter mentioned above? I am a little confused.

     

    Best Regards!

    Yolo Zhu

    • GokilaRaviraj's avatar
      GokilaRaviraj
      Helper II
      1 year ago

      Hi Anonymous 

      Sorry for the confusion.

       

      1) This entire calculation has to be done only when Current month is jan. 

      Otherwise from next month onwards, Calculation is not needed. Whatever values we have calculated on Jan month on this table for febcfy,Maycfy,Augcfy,Novcy,Febnfy,Maynfy,Augnfy and Novnfy for these columns should be retained. 

      Table will start show months from FebCfy to Decnfy the next month as per my calendar table.

      Since our input table will not have previous quarters, we can not do the calculations again on the upcoming months. 

       

      2) I need this calculation as a calculated column since i need to use this table and values further to proceed with append query. Could you please help me with this?