Data wants in different column Reporting Month Wise

Question

Hi All,

Could you please help me to get the in last column (Amount) the data coming from green column. so, If I am sitting in May then May data wants in to last column, if in June then June data want in last column. so how I can get the data like this way. Please help me to build workflow for same.

Thanks,

Rajeev

TUSHAR050392 · Answer

Hey @Rhaldhar Another approach -

If your data is going to have columns for all 12 months then you can simply go for a formula tool using IF Else statement creating a new column - Amount.

IF DatetimeMonth(Datetimetoday()) = 1 THEN [1/31/2024] ELSEIF

DatetimeMonth(Datetimetoday()) = 2 THEN [2/29/2024] ELSEIF ......

Continue till December

Hope this helps

Raj · Answer

@Rhaldhar 
find the workflow attached

mark done if solved.

3314.yxmd

OTrieger · Answer

The above is a guidance, the general steps on how to get the data there, work it out form your hand what is exactly needed to be done.
You know that you need to transpose the data to get the dates to so you can check which month it is, this is the tip here, the ball is in your hands now.