Hi team,
Please find the attachment of .twbx i do have two sheet Invoice Status report and target Sheet, I have done cumulative function of Cumulative CaLculation ,
The issue i am facing is i need Invoice Id from Invoice status report sheet and i am performing respective calculation :
IF [Invoice Released Date]<DATE([Date_Selection_Para])
AND
DATEDIFF('month',[Invoice Released Date],DATE([Date_Selection_Para]-1))<1
THEN ATTR([Invoice Status Report+ (ISR)].[Invoice ID])
END
This calculation giving me error, The calculation i am performing if i select any date in parameters i.e Date selection para it will give start of that month with Cumulative Calculation
same i am looking for invoice Id count with is from Invoice status report sheet .
Hi Rakesh,
I am not exactly sure, but may be this?
Regards,
Shin