Issue in calculating monthly trend from accumulated field

[sarfaraz_sheikh]

Hello Everyone,

I want monthly trend of Apr-Mar of a particular field i.e, (NEP+TP_NEP).

I am using below mentioned expression for the same :

=if(WildMatch(Month,'Apr'),(sum({<Freeze_Date={">=$(vYTDStart)<=$(vYTDEnd)"}, FiscalYearDesc=, Month=>}NEP)+sum({<Freeze_Date={">=$(vYTDStart)<=$(vYTDEnd)"}, FiscalYearDesc=, Month=>}TP_NEP)),

            ((sum({<Freeze_Date={">=$(vYTDStart)<=$(vYTDEnd)"}, FiscalYearDesc=, Month=>}NEP)+sum({<Freeze_Date={">=$(vYTDStart)<=$(vYTDEnd)"}, FiscalYearDesc=, Month=>}TP_NEP))-

                Above((sum({<Freeze_Date={">=$(vYTDStart)<=$(vYTDEnd)"}, FiscalYearDesc=, Month=>}NEP)+sum({<Freeze_Date={">=$(vYTDStart)<=$(vYTDEnd)"}, FiscalYearDesc=, Month=>}TP_NEP)))))/10000000

But with this expression I am not getting value for the month of Apr.

Requesting you to guide me to get proper output from Apr to Mar.

Eg:

Actual data

Month     NEP

Apr         100

May        120

Jun         180

Jul           200

O/P required:

Month     NEP

Apr          100

May         20(May-Apr)

Jun          60(Jun-May)

Jul          20 (Jul-Jun)

so on and so forth..

Thank you in advance...

hic‌gwassenaar‌jagan‌ Please help !!!

Regards,

Sarfaraz Sheikh

[Anil_Babu_Samineni]

Try to share the Sample

Or else PFA

[sunny_talwar]

I think as Anil pointed out, we will be able to help better if you can provide the sample application.

Preparing examples for Upload - Reduction and Data Scrambling