Need help in getting ifElseIf output value from one table to other

Ask for Help
1

Hey Guys,

I have a table A which has revenue targets broken down monthwise

like Jan, Feb, March etc each month

I have a column called now_month which calculates the current month and then compares it with Date column to determine which month it is currently

I have If Else If column which checks which now_month and Date to give revenue target as output.

So all rows will not have value only some rows will have value.

I have another table called Dashboard where I need to be able to pull this out put of IfElseIf so that I can display it for a progress bar.

How would I be able to do it?

Currently I tried importing ifElseIf output using single value column to dashboard table. its giving some random values based on single value selection config. How can we overcome this?

Thank you Guys.

Regards,
Dilip

2

Hi Guys,

I took the wrong approach. I should not have taken ifElseIf column in first place.

It should have been query column.

Sorted the issue.

Thank you.

Regards,
Dilip

3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.