Result Set is not getting properly in if condition

bvssudhakar — Sat, 16 Nov 2024 18:05:06 GMT

Hi Community,

I Have one variable named as 'v_PortfolioManagerId'... I want to use this variable for filter pane so that i have created measure like this : if(PortfolioManagerId=v_PortfolioManagerId, CycleID)

Now I want add one more condition for this filter 'if(GetFieldSelections(PortfolioManager)<>null()' it should show all cycledID's otherwise it should show this condition cycleid's only if(PortfolioManagerId=v_PortfolioManagerId, CycleID)

I tried these two expressions but i am not getting the result set properly.... Can you guys please check and let me know what i missed. Itried all these Expressions

If(Len(Trim(PortfolioManager)) =0,if(PortfolioManagerId=v_PortfolioManagerId, CycleID),CycleID)

if(PortfolioManagerId<>v_PortfolioManagerId and GetFieldSelections(PortfolioManager)<>null(), CycleID,if(PortfolioManagerId=v_PortfolioManagerId, CycleID))

Can you guys please help me out from this

Thanks In Advance

B V S S

topic Result Set is not getting properly in if condition in App Development

Result Set is not getting properly in if condition