duncan
2
Hello @Mayur1 !
I’m not sure I understand where you are running into trouble here. Is this calculated field throwing an error or not returning the expected values?:
ifelse(
Application <= ${Dateselection2} AND
Application >= truncDate(‘MM’, ${Dateselection2}),
{Total Cost with CSP},
0)
If you want to use that with a LAC function you could try wrapping it in something like a sumOver and partition by a dimension in your dataset.
1 Like