Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Here is my expression on a table. How to rewrite so it is calculated on load editor instead ?
vFY = 2023
MonthNum1 = 09
If(Sum({<[Fiscal Year]={'$(vFY)'},$(s_MonthNum1)>} Sales ) > 0, '',
If(Sum({<[Fiscal Year]={'$(vFY0)'},$(s_MonthNum1)>}Order )
/Sum({<[Fiscal Year]={'$(vFY0)'},$(s_MonthNum1)>} Equipment ) >= .8, 'FY'&Right($(vFY0),2), ' '))
Generally speaking, replace your set analysis with Where conditions in the load script - Where Fiscal Year = 2023 and Month = 09. If() and sum() syntax otherwise stays the same. You may need to add a Group By by whatever dimensions you're using on the front end.
....