Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
IF(
[Select_Month ] = '01' OR [Select_Month ] = '02' OR [Select_Month ] = '03',
IF(
YearMonthDateString = ((right([Current Fiscal Year],4)) & '-' & [Select_Month ] & '-01') AND Version = 'PYACT_CYBUDRATE - PY Actuals at CY Budget Rate',
Adj_value,
IF(
YearMonthDateString = ((right([Current Fiscal Year],4)-1) & '-' & [Select_Month ] & '-01') AND Version = 'PYACT_CYBUDRATE - PY Actuals at CY Budget Rate',
Adj_value
)
)
)
where Adj_value = sum ( vcurrency*value), v currency is variable to make currency selection
yearmonthdatestring is string format of date field in dataset
HI @vinayk1
You need to start simple, check that works and layer parts on until it breaks, then you will know what to fix. You have nested IF statements that seem to do the same at the end of them. The spaces inside the square brackets looks like they could be wrong, unless they are in your column names.
I would just start with an expression of sum(value) and see if that works, then sum(vcurrency*value) then if you want to put that in a variable (which I assume is what Adj_value is?) then you can try $(Adj_value) then add the IF structure a bit at a time.
Hope that helps,
Steve